虎子哥的博客

Posts Tagged ‘mysql

08 四, 2011

mysql/sqlite批量执行命令

Posted by: indream In: ios开发

进入终端命令行 mysql: mysql.txt里面可以n句sql或者其它可执行语句,例如 load data local infile '~/path/001.csv' into table tb_database fields terminated by '|'; load data local infile '~/path/002.csv' into table tb_database fields terminated by '|'; load data local infile '~/path/003.csv' into table tb_database fields terminated by '|'; ... sqlite: mysql.txt里面可以n句sql或者其它可执行语句,例如 CREATE TABLE IF NOT EXISTS tb_database (id INTEGER,name TEXT); .separator "|" .import 001.csv [...]

Tags: ,