Slayer_Lc的专栏

mysql> update order_info set province_id=15 ,city_id= 1667 where order_from=10 and order_out_sn='1407261241xxxx'; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction mysql>

每月的数据:select * from table t where date_format(‘2015-01-01’,'%Y-%m') = date_format(kh_createtime,'%Y-%m'); 每周的数据:select * from table t where (select date_add(date('2015-01-01'),INTERVAL -weekday('2015