Where database_name.db is replaced with your desired database name and file extension. The basic sqlite3 syntax for creating a new SQLite database is: sqlite3 database_name.db Navigate to the directory where you want to create the SQLite database.įor example, to create a database in your user’s home folder: # Mac/LinuxĬd %HOMEPATH% Basic Syntax for Creating a Database Opening the Command Prompt or Terminalįirst, find the Terminal (Mac/Linux) or Command Prompt (Windows) app. We’ll use it to create a new database file. The main SQLite command line tool is called sqlite3. ![]() Step-by-Step Guide to Creating a SQLite Database That’s it! The bare essentials to start working with SQLite. Optional SQLite Tools – User-friendly GUI tools like DB Browser for SQLite. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |