mysql 相关语句

数据库导入导出

mysqldump -u root -p uebuycar_test >test.sql
mysql -u root -p uebuycar_new<test.sql  

时间增加/减少 1个月 时分秒不变

UPDATE web_user set create_time = ADDTIME(date(create_time)+interval 1 month,time(create_time))
where create_time>='2013-09-01 00:00:00' and create_time<='2013-09-21 23:59:59'
order by create_time
 limit 1;


UPDATE web_user set create_time = ADDTIME(date(create_time)-interval 1 month,time(create_time))
where create_time>='2013-09-01 00:00:00' and create_time<='2013-09-21 23:59:59'
order by create_time
 limit 1;

查询插入，主要可用于备份

insert into uebuycar_test.web_user select * from uebuycar_product.web_user a 
where a.create_time >='2015-01-19 18:25:00';