Sqliteman - Simple sqlite3 browser and editor.įor tools supporting multiple DBMSs, see List of applications/Documents#Database tools. ![]() DB Browser for SQLite - High quality, visual, open source tool to create, design, and edit database files compatible with SQLite.Search database sqlite> select * from tblone Sqlite> insert into tblone values('archlinux', 30) Insert data sqlite> insert into tblone values('helloworld',20) ![]() The SQLite library includes a simple command-line utility named sqlite3 that allows the user to manually enter and execute SQL commands against an SQLite database.Ĭreate a database $ sqlite3 databasename Create table sqlite> create table tblone(one varchar(10), two smallint)
0 Comments
Leave a Reply. |