I am beginner in Sqlite programming. I already open and read tables.
I compiled sqlite3.c (8 MB) amalgamation file do DLL and call functions
Which function are for crating new database, tables, indices, columns, fill
#define SQLITE_CREATE_INDEX 1 /* Index Name Table Name
#define SQLITE_CREATE_TABLE 2 /* Table Name NULL
but how function I must call?
sqlite-users mailing list
[hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
To create a new database you just open the file name you want, and if it doesn't exist it will be created.
The actual new file creation is slightly delayed until it has to write something to the disk. There are a couple of options that can only be set at file creation time like page size, text encoding, file format, etc. So if you wanted any non-default settings for those you would set those first thing after opening it and before doing anything else, so that they are set _before_ the actual file itself is created.
From: sqlite-users <[hidden email]> On Behalf Of Andy
Sent: Tuesday, January 7, 2020 9:23 AM
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] How create database, tables,indices...