mysql -h10.10.10.2 -uroot -proot dbName -e "select * from tableName" > E:/TABLE_DATA这样导出的 TABLE_DATA 里内容是这样id name
0 aaa
1 bbb
....
然后用
mysql -h10.10.10.2 -uroot -proot dbName -e "load data local infile 'E:/TABLE_DATA' into table myTable"这样的话,第一条记录就会变成字段名。.
0 aaa
1 bbb
....
然后用
mysql -h10.10.10.2 -uroot -proot dbName -e "load data local infile 'E:/TABLE_DATA' into table myTable"这样的话,第一条记录就会变成字段名。.
+------+------+
| id | name |
+------+------+
| 0 | aaa |
| 1 | bbb |
+------+------+
2 rows in set (0.00 sec)[code=BatchFile]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn -e "select
* from t_aj3423 INTO OUTFILE 'c:/TABLE_DATA'"C:\Program Files\MySQL\MySQL Server 5.1\bin>type c:\TABLE_DATA
0 aaa
1 bbb[/code]
mysql> delete from t_aj3423;
Query OK, 2 rows affected (0.08 sec)mysql> select * from t_aj3423;
Empty set (0.00 sec)
[code=BatchFile]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn -e "LOAD DA
TA INFILE 'c:/TABLE_DATA' INTO TABLE t_aj3423"C:\Program Files\MySQL\MySQL Server 5.1\bin>[/code]
mysql> select * from t_aj3423;
+------+------+
| id | name |
+------+------+
| 0 | aaa |
| 1 | bbb |
+------+------+
2 rows in set (0.00 sec)mysql>
mysql -h10.10.10.2 -uroot -proot dbName -e "select * from tableName" > E:/TABLE_DATA
是把数据导出到客户端的 E:/TABLE_DATAC:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn -e "select
* from t_aj3423 INTO OUTFILE 'c:/TABLE_DATA'"
这样就导出到mysql服务器上了可能就是这个关系,把select出来的东西传过来就会 带上字段
在你的load data infrile 中加上 IGNORE number LINES 选项就行了
-> (0,'aaa'),
-> (1,'bbb');
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0mysql> select * from t_aj3423;
+------+------+
| id | name |
+------+------+
| 0 | aaa |
| 1 | bbb |
+------+------+
2 rows in set (0.00 sec)mysql>
[code=BatchFile]
C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn -e "select * from t_aj3423" > c:\TABLE_DATAC:\Program Files\MySQL\MySQL Server 5.1\bin>type c:\TABLE_DATA
id name
0 aaa
1 bbbC:\Program Files\MySQL\MySQL Server 5.1\bin>[/code]mysql> delete from t_aj3423;
Query OK, 2 rows affected (0.05 sec)mysql> select * from t_aj3423;
Empty set (0.02 sec)mysql>
[code=BatchFile]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p123 csdn -e "LOAD DATA INFILE 'c:/TABLE_DATA' INTO TABLE t_aj3423 LINES TERMINATED BY '\r\n' IGNORE1 LINES"
[/code]mysql> select * from t_aj3423;
+------+------+
| id | name |
+------+------+
| 0 | aaa |
| 1 | bbb |
+------+------+
2 rows in set (0.00 sec)mysql>
加上 -N 不导出列名
-N, --skip-column-names
Don't write column names in results. WARNING: -N is
deprecated, use long version of this options instead.