SQLite
2011/06/08 00:14
瀏覽200
迴響1
推薦0
引用0
SQLite
http://www.sqlite.org/
真好用!
/*===
建立命令檔.sql
BEGIN TRANSACTION;
CREATE TABLE table01 (id , name , pass );
INSERT INTO "table01" VALUES('1','ddd','ddd');
INSERT INTO "table01" VALUES('2','perl','cpan');
INSERT INTO "table01" VALUES('3','aaa','bbb');
INSERT INTO "table01" VALUES('5','sss','ggg');
INSERT INTO "table01" VALUES('6','sss',NULL);
COMMIT;
*/===
/*===
執行指令檔
sqlite3 XXXX.db < XXXX.sql
*/===
就可以使用了!
http://www.sqlite.org/
真好用!
/*===
建立命令檔.sql
BEGIN TRANSACTION;
CREATE TABLE table01 (id , name , pass );
INSERT INTO "table01" VALUES('1','ddd','ddd');
INSERT INTO "table01" VALUES('2','perl','cpan');
INSERT INTO "table01" VALUES('3','aaa','bbb');
INSERT INTO "table01" VALUES('5','sss','ggg');
INSERT INTO "table01" VALUES('6','sss',NULL);
COMMIT;
*/===
/*===
執行指令檔
sqlite3 XXXX.db < XXXX.sql
*/===
就可以使用了!
限會員,要發表迴響,請先登入
迴響(1) :
- 1樓. 凱雅斯2011/11/08 11:43proxy log 剥洋蔥
($IN_IP , $S1_datas )= split(/ - - /,$records);
($IN_Time , $S2_datas )= split(/]/,$S1_datas);
$IN_Time=substr($IN_Time,1);
($S31_datas , $S32_datas , $S33_datas , $S34_datas)= split(/ "/,$S2_datas);
($IN_Method , $S4_datas ) = split(/" /,$S32_datas);
($IN_Port_S , $IN_Port_M) = split(/ /,$S4_datas);
($IN_URL , $S5_null) = split(/"/,$S33_datas);
($IN_Browser , $IN_TCPmiss) = split(/" /,$S34_datas);

