Sqlite3 the process of creating a new database

Some things, very simple, but there is a hole, it becomes complicated. Let me first say the simplest way, create a new empty TXT document, and then change the suffix to db. -_-egg pain, in fact, I do not know at the beginning, but also after the success of the new DB found in the DB 0kb only boldly made this attempt.

First of all, it is useless to use the CREATE DATABASE command, which is not the same as the MySQL tool.

I want to create a new database, mainly to use Sqlite3 in LUA code, and then see the list of functions, there is no corresponding function of the new database. Later found to use the Open function, enter the name of the database, if there is a direct connection, if not present, will automatically create a new one. -_-Egg ache, actually at the beginning I also do not know, successful new db to do this kind of attempt boldly.

Finally, the formal method, using Sqlite3.exe to generate. Download the tool http://www.sqlite.org/download.html first, you need to download Sqlite-tools-win32-x86-xxxxxx.zip and Sqlite-dll-win32-*.zip, Then the sqlite-dll extracted files into the sqlite-tools extracted files, because sqlite3.exe to use the corresponding DLL. Run CMD,CD to the corresponding directory, execute Sqlite3.exe your-name.db, originally to this step, the database should be generated, but because of the caching reasons, not really generated, at this time you execute the next command:. Databases This command is to display all the databases that are currently managed , and then you see just the database, the corresponding folder also appeared your-name.db file. Cache there, feel good pit-_-

Sqlite3 the process of creating a new database