论坛风格切换
  • 2888阅读
  • 0回复

[mysql]常用mysql命令 [复制链接]

上一主题 下一主题
离线谯周
 

发帖
142
金币
0
威望
55
只看楼主 倒序阅读 使用道具 楼主  发表于: 2011-07-14

LOAD DATA INFILE  '/tmp/399183.sql' INTO TABLE database.pw_threads;
SELECT * FROM `table` WHERE tid=399183 INTO OUTFILE 'd:\399183.sql';
mysqlbinlog --stop-position="368312" /var/log/mysql/bin.123456 |mysql -u root -pmypwd
mysqlbinlog --start-position="368315" /var/log/mysql/bin.123456 |mysql -u root -pmypwd
mysqlbinlog --stop-date="2005-04-20 9:59:59" /var/log/mysql/bin.123456 |mysql -u root -pmypwd
mysqlbinlog --start-date="2005-04-20 10:01:00" /var/log/mysql/bin.123456 |mysql -u root -pmypwd









快速回复
限100 字节
批量上传需要先选择文件,再选择上传
 
提到某人:
选择好友
上一个 下一个