Re: [sqlite] How create database, tables,indices...

[David Raymond]

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.


-Original Message-
From: sqlite-users  On Behalf Of 
Andy
Sent: Tuesday, January 7, 2020 9:23 AM
To: SQLite mailing list 
Subject: Re: [sqlite] How create database, tables,indices...

I see: http://zetcode.com/db/sqlitec/
New database is simply open not existing file in path?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How create database, tables,indices...

[Simon Slavin]

On 7 Jan 2020, at 2:11pm, Andy  wrote:

> Which function are for crating new database, tables, indices, columns, fill 
> tables.

You do this with SQL commands, just like the commands you use to read data out 
of the database.



On 7 Jan 2020, at 2:23pm, Andy  wrote:

> New database is simply open not existing file in path?

Your path is for files you execute.  You do not execute a database file.  So if 
the database is not in your current directory you must specify the directory it 
is in.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How create database, tables,indices...

[Andy]

I see: http://zetcode.com/db/sqlitec/
New database is simply open not existing file in path?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users