昨天问了你。从sqlite 批量导出来到csv文件sqlite3 -header -csv db1 "select * from t1" >> t1.csv
sqlite3 -header -csv db2 "select * from t1" >> t1.csv
sqlite3 -header -csv db3 "select * from t1" >> t1.csv
如何把csv文件导入到 mysql呢?或者说从sqlite直接导到mysql呢?phpmyadmin中有csv导入到mysql的功能。可是我怎么也导不进去?
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
在哪里对应 字段名 和 数据库名呢? 以及数据库密码之类的呢?
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.36-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use test;
Database changed
mysql> load data local infile "D://test/1.txt" into table t;
ERROR 2 (HY000): File 'D:\\test\1.txt' not found (Errcode: 2)
mysql>
用MYSQL命令工具先进入,或者直接在你的可以执行SQL语句的工具中都可以执行这个 load data infile.http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#load-data
13.2.5. LOAD DATA INFILE语法