2.增加
insert into t_emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (1,‘SMITH‘,‘CLERK‘,3,‘1980-5-12‘,800,null,20);
3.
SQLite建表和增删改示例
标签：
SQLite建表和增删改示例
table t_emp(
empno Integer PRIMARY KEY autoincrement,
ename varchar(20),
job varchar(10),
mgr Integer,
hiredate date,
sal REAL,
comm REAL,
deptno int
);