mysql导出txt样例_MySQL样例数据导入

****************** 样例数据导入 *******************/

/** 官网下载 http://dev.mysql.com/doc/index-other.html **/

/******** db1、menagerie ********/

/******* cmd登录mysql *******/mysql-P3307 -uroot -pCREATE DATABASEmenagerie;USEmenagerie;

source E:/MySQL/ExampleDatabases/menagerie-db/cr_pet_tbl.sqlLOAD DATA LOCAL INFILE ‘E:/MySQL/ExampleDatabases/menagerie-db/pet.txt‘ INTO TABLE pet; # Load中只能用/，其他的\与/都可以使用，它们的区别是什么

SOURCE E:/MySQL/ExampleDatabases/menagerie-db/ins_puff_rec.sql

SOURCE E:/MySQL/ExampleDatabases/menagerie-db/cr_event_tbl.sqlLOAD DATA LOCAL INFILE ‘E:/MySQL/ExampleDatabases/menagerie-db/event.txt‘ INTO TABLEEVENT;/******** command interpreter ********/#切换到.sql/.txt文件所在目录

e:

cd E:\MySQL\ExampleDatabases\menagerie-db

#cd E:/MySQL/ExampleDatabases/menagerie-db

mysql-P3307 -uroot -p menagerie

mysql-P3307 -uroot -p menagerie

mysqlimport-P3307 -uroot -p menagerie E:\MySQL\ExampleDatabases\menagerie-db\pet.txt #需指定路径，不然就 File ‘E:\mysql\mysql-5.7.15\data\menagerie\xx.txt‘ notfound

#mysqlimport-P3307 -uroot -p menagerie E:/MySQL/ExampleDatabases/menagerie-db/pet.txt

mysql-P3307 -uroot -p menagerie

mysql-P3307 -uroot -p menagerie

mysqlimport-P3307 -uroot -p menagerie E:\MySQL\ExampleDatabases\menagerie-db\event.txt/******** db2、sakila ********/

/******* cmd登录mysql *******/mysql-P3307 -uroot -pCREATE DATABASEsakila;USEsakila;

source E:/MySQL/ExampleDatabases/sakila-db/sakila-schema.sql

source E:/MySQL/ExampleDatabases/sakila-db/sakila-data.sql/******** db3、world ********/

/******* cmd登录mysql *******/mysql-P3307 -uroot -pCREATE DATABASEworld;USEworld;

source E:/MySQL/ExampleDatabases/world.sql/******** db4、world_x ********/

/******* cmd登录mysql *******/mysql-P3307 -uroot -pCREATE DATABASEworld_x;USEworld_x;

source E:/MySQL/ExampleDatabases/world_x-db/world_x.sql

MySQL样例数据导入

标签：href   data   压缩文件   span   class   cmd   erp   mysqli   index

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/ShanFish/p/6259835.html