The sqlite3 command is used to create database. But, if the database does not exist then a new database file with the given name will be created automatically.<\/p>\n
cmd:sqlite3 test.db<\/strong><\/p>\n -> To see the databases:<\/p>\n cmd:\u00a0.databases\u00a0\u00a0<\/strong><\/p>\n -> To quit from the database<\/p>\n cmd: .quit<\/strong><\/p>\n ->dump Command:The .dump dot command is used to export complete database in a text file by using SQlite command at command prompt.<\/p>\n cmd: sqlite3 test.db\u00a0.dump\u00a0> test.sql\u00a0\u00a0<\/strong><\/p>\n Attach database:<\/strong><\/p>\n To select a particular database and after using this command, all SQLite statements will be executed under the attached database.<\/p>\n cmd:ATTACH\u00a0DATABASE<\/span>\u00a0‘DatabaseName’<\/span>\u00a0As<\/span>\u00a0‘Alias-Name’<\/span>;\u00a0 \u00a0<\/strong><\/p>\n Note: It will also create a database if the database is not already present, otherwise it will only attach a database file name with the logical database Alias-Name.<\/p>\n Detach Database:<\/strong><\/p>\n It is used to detach the alias-named database from a database connection which was previously attached by using ATTACH statement.<\/p>\n cmd: DETACH\u00a0DATABASE<\/span>\u00a0‘Alias-Name’<\/span>\u00a0\u00a0<\/strong><\/p>\n To see the list tables:<\/p>\n cmd: .tables<\/strong><\/p>\n SQLite Import:<\/strong><\/p>\n -> Import a CSV file into SQLite table by using sqlite3 tool and .import command. This command accepts a file name, and a table name.<\/p>\n ->\u00a0Here, file name is the file from where the data is fetched and the table name is the table where the data will be imported into. In the absence of the table, it will create the table automatically according to the data in CSV file.<\/p>\n cmd: .mode\u00a0csv <\/strong><\/p>\n cmd:.import\u00a0\/Users\/javatpoint1\/Desktop\/sqlite\/student.csv\u00a0EMPLOYEE\u00a0<\/strong><\/p>\n To see the records:<\/p>\n cmd: .mode\u00a0column<\/span>\u00a0\u00a0<\/strong><\/p>\n cmd:\u00a0SELECT<\/span>\u00a0*\u00a0FROM<\/span>\u00a0EMPLOYEE;\u00a0 \u00a0<\/strong><\/p>\n Note: .mode column is used before SELECT statement to show the data in tabular form and specifies the columns.<\/p>\n SQLite Export:<\/strong><\/p>\n \u00a0-> To export data from SQLite database to CSV file. We can export the whole table or less according to your query.<\/p>\n -> .once command is used to export data to a CSV file followed by the file path\/name where we want to write the file.<\/p>\n cmd: .header\u00a0on<\/span>\u00a0\u00a0<\/strong><\/p>\n cmd: .mode\u00a0csv\u00a0\u00a0<\/strong><\/p>\n cmd: .once\u00a0\/Users\/javatpoint1\/Desktop\/sqlite\/student.csv\u00a0\u00a0<\/strong><\/p>\n cmd: SELECT<\/span>\u00a0*\u00a0FROM<\/span>\u00a0STUDENT;\u00a0\u00a0<\/strong><\/p>\n Code explanation:<\/strong><\/p>\n .header on:<\/strong>\u00a0It specifies that headers are enabled. This is optional. If you disable headers, the CSV file simply won’t contain any data.<\/p>\n .mode csv:<\/strong>\u00a0It specifies that CSV mode is enabled.<\/p>\n .once:<\/strong>\u00a0It specifies that the output to be written to the CSV file and next is the exact location.<\/p>\n After execution of the above code, a CSV file is created on the specified location.<\/p>\n -> To open the csv file automatically<\/p>\n cmd: .system\u00a0\/Users\/javatpoint1\/Desktop\/sqlite\/student.csv\u00a0\u00a0<\/strong><\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n –<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" -> SQLite is an open source, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application. ->\u00a0SQLite does not have a separate server process. It…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":""},"categories":[1],"tags":[],"yoast_head":"\n![\"Sqlite](\"https:\/\/www.javatpoint.com\/sqlite\/images\/sqlite-import1.png\")
<\/p>\n![\"Sqlite](\"https:\/\/www.javatpoint.com\/sqlite\/images\/sqlite-import3.png\")
<\/p>\n![\"Sqlite](\"https:\/\/www.javatpoint.com\/sqlite\/images\/sqlite-export2.png\")
<\/p>\n