mysqldump的导出数据表的方法

by alpha 18. April 2008 15:30
mysqldump -u root --add-drop-table --opt database c>c.txt mysqldump -u root --no-create-info --where="id>1441" database t>t.txt   1.导出数据表c的全部内容到c.txt,并且在创建表之前添加DROP命令 2. 导出数据表t的数据到t.txt,并且判断id字段>1441,不导出结构,只导出数据。  

Tags: Views:1743

SqlServer

<< Prev 1 Next >>

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen  浙ICP备09023819号  

关于作者

Alpha

1.男
2.已婚
3.网虫
4.宝宝叫yoyo

Calendar

<<  July 2010  >>
MondayTuesdayWednesdayThursdayFridaySaturdaySunday
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar

RecentComments

Comment RSS