sqlite3

sqlite3 test.db

create table Employee(eno integer PRIMARY KEY AUTOINCREMENT NOT NULL, ename varchar(25), sal int);

insert into Employee values(1,'abc',1000);
insert into Employee (ename) values('abc');

select * from Employee;
select * from Employee where eno=1;
select * from Employee order by ename DESC ; #ASC

update Employee set ename='xyz ' where eno=3;

DELETE FROM Employee WHERE eno = 1;
DELETE FROM Employee;

DROP TABLE Employee;



.schema Employee
.tables
.separator :
.show
.header on
.mode column

eg)


CREATE TABLE cs3(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, name text, sid text, email text, re1 integer, re2 integer, re3 integer, re4 integer, pt1 integer, pt2 integer, test1 integer, test2 integer, test3 integer, test4 integer, hw1 integer, hw2 integer, hw3 integer, hw4 integer, act integer, total integer);

(id, 'name', 'sid', 'email', re1, re2, re3, re4, pt1, pt2, test1, test2, test3, test4, hw1, hw2, hw3, hw4, act, total)

(id, 'name', 'sid', 'email', 1, 2, 3, 4, 1, 2, 1, 2, 3, 4, 1, 2, 3, 4, 1, 100)

insert into huree values(1, 'name', 'sid', 'email', 1, 2, 3, 4, 1, 2, 1, 2, 3, 4, 1, 2, 3, 4, 1, 100);