1

MySQL导出指定数据到sql文件

 3 years ago
source link: http://www.blogjava.net/layxue/archive/2021/02/20/435802.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

  BlogJava :: 首页 :: 联系 :: 聚合  :: 管理

  5 Posts :: 0 Stories :: 0 Comments :: 0 Trackbacks

使用mysqldump进行导出，语句如下：
mysqldump -u root -p123456 test tbuser --where="1=1 limit 5,10">D:\user.sql
以上语句意为：把tbuser表的第6至15条数据导出
root为用户名，123456为密码，test为数据库名字，tbuser为表名

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK