##导出整个数据库结构和数据
mysqldump -h localhost -uroot -p123456 database > dump.sql
mysqldump -h localhost -uroot -p123456 database | gzip > dump.sql.gz
##导出单个数据表结构和数据
mysqldump -h localhost -uroot -p123456 database table > dump.sql
##导出整个数据库结构 (不包含数据)
mysqldump -h localhost -uroot -p123456 -d database > dump.sql
##导出单个数据表结构 (不包含数据)
mysqldump -h localhost -uroot -p123456 -d database table > dump.sql
## 随机取出5000条数据
SELECT * FROM dw_cell_trade_detail ORDER BY RAND() LIMIT 5000
## delete关联表删除数据
DELETE t1 FROM dw_cell_trade_detail t1,dw_cell_trade_detail_test t2 WHERE t1.id = t2.id
## 从本地文件导入表中
LOAD DATA LOCAL INFILE 'D:/tmp/dw_cell_esf_quoted_info/000000_0' INTO TABLE dw_cell_esf_quoted_info FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n';
mysql导出库结构和表数据
最新推荐文章于 2024-07-03 03:27:59 发布