[Mysql] 一些记录
1> 修改表的字段
alter table trade_market change reqype reqtype int(10) unsigned not null;
alter table trade_market drop column reqtype;
alter table trade_market add column `resnum` int(10) unsigned not null after `reqtype`;
2> 设置密码
update mysql.user set password=PASSWORD('新密码') where User='root'; flush privileges;
3> binlog 查看 参考http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog-row-events.html
mysqlbinlog -vv /var/lib/mysql/mysql-bin.000281 --start-datetime='2015-07-02 13:17:02' --stop-datetime='2015-07-02 13:17:05' > d2.sql