[Sqlite3] How to use sqlite command to create db and table

[Sqlite3] How to use sqlite command to create db and table



1. Create Database the name was called test.db

sqlite3 test.db



2. Create table the name was called manages

create table manages(id integer primary key, name text);

insert into manages(id,name) values(1, 'Freeman');

insert into manages(name) values('Good');



3. Display mode

.mode column  (Column)

.headers on      (Have header or not [1])

select * from manages;





.width 15 20      (First column size 15, Second column size 20)

select * from manages;



.tables                (Show which table edit at now)

.mode line         ([2])





.schema             ([3])

.show



Example :

[1]

sqlite> .headers on

sqlite> select * from manages;

id|name  <-- Header

2|Good

3|

4|

sqlite>



[2]

sqlite> select * from manages;

id|name

2|Good

3|

4|

sqlite> .mode line

sqlite> select * from manages;

   id = 2

 name = Good



   id = 3

 name =



   id = 4

 name =



[3]

sqlite> .schema

CREATE TABLE "manages"(id integer primary key, name text);



Reference:

• 
  SQLite3 Tutorial