1、首先进入sqlite3.exe.开始—>运行—>cmd—>D:—>D:\vs2008\windows\db—>sqlite3.exe test.db。
至此已将创建数据库test。
2、可以在D:\vs2008\windows\db目录下创建文件1.sql,内容如下:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE snw12(SN varchar(30) not null,ERRORCODE interger not null,strTIME TIMESTAMP default (datetime('now','localtime')),FLAG interger not null,PID varchar(12) not null,primary key(SN,ERRORCODE));
INSERT INTO "snw12" VALUES('w123',10000001,'2012-08-16 08:20:30','A000135','1');
INSERT INTO "snw12" VALUES('w123',0,'2012-08-16 08:25:30','A000135','1');
INSERT INTO "snw12" VALUES('w124',1000010,'2012-08-16 09:25:30','A000135','1');
INSERT INTO "snw12" VALUES('w124',0,'2012-08-16 10:25:30','A000135','1');
COMMIT;
sqlite>.read 1.sql (已经将数据导入数据库test)
sqlite>.table (显示数据库test中所有的表名)
sqlite>.select * from 表名; (查看表中数据)
sqlite>.dump 表名 (查看表中字段的类型)
sqlite>.output 2.sql (将表信息导出,内容如1.sql)
sqlite>.quit (退出数据库)