关于sqlite的一些语句

 

创建
CREATE TABLE A(isDo  char(10) PRIMARY KEY,isWrong  char(8)  NOT NULL,chose char(8),tiHao INTEGER )  
create table temp as select * from A;


更新一列的多个数据
update tableA set isDo=(select isDo from tableB where tiHao=tableA.tiHao)


改名
ALTER TABLE tableA RENAME TO tableB ; 

删除
DROP TABLE tableA ;


插入
INSERT INTO tableA(key_id, key_name, key_age)VALUES(0 "name", 90);
添加一列
alter table tableName add (columnName typeName);

例：alter table myTable add (myColumn varchar2(10))

合并两个表
  select * from tableA e union select * from tableB 


导入 数据并过滤
insert into tableA  select distinct * from tableB 
 
清除表tableA 数据

delete from tableA ; 

/test 附加 当前数据库 
ATTACH  DATABASE 'C:\Users\Administrator\Desktop\test.db' AS 'one'