How to create a new database using python and sqlite3

user_234322 0
Viewed 54807
import sqlite3

conn = sqlite3.connect(r"D:\aaa.db")

Is there a way to automatically create the db file if it doesn't already exist when I connect to it?

sqlite python
6 Answers

The code you give does create 'D:\\aaa.db' if it doesn't exist.

user_958100

If it isn't created automatically, make sure that you have the directory permissions correct

user_1747280

Pretty sure .connect will create the file if it doesn't exist.

user_573480
Related