LEN

Mysql 命令行导出 导入 数据
导入表数据source /home/root/example.sql 导出表数据mysql> select ...
扫描右侧二维码阅读全文
10
2017/01

Mysql 命令行导出 导入 数据

导入表数据

source /home/root/example.sql 

导出表数据

mysql> select * from table into outfile ‘/home/root/example.sql' where +条件

导入数据库

mysql -uroot -p --default-character-set=utf8 dbname < /home/root/example.sql 

导出数据库

mysqldump -uroot -p --default-character-set=utf8 dbname tablename >  /home/root/example.sql 

转载数据

 mysql>load data local infile ‘/home/table.txt' into table `table`; 
Last modification:February 8th, 2017 at 02:19 pm
If you think my article is useful to you, please feel free to appreciate

Leave a Comment