- #查询商户名称
- SELECT * FROM sim WHERE card_merchant is not NULL AND card_merchant!='' GROUP BY card_merchant;
- #查询某两个时间内的数据
- SELECT * FROM sim WHERE deadline is not NULL AND deadline!='' and card_merchant='langxing' and TIMESTAMPDIFF(MONTH,deadline,'2017-02-16');
- update sim set activeTime='2015-10-01 11:15:27' WHERE deadline is not NULL AND deadline!='' and card_merchant='langxing' and TIMESTAMPDIFF(MONTH,deadline,'2017-02-16');
- update sim set deadline='2016-12-01 11:15:27' WHERE deadline is not NULL AND deadline!='' and card_merchant='langxing' and TIMESTAMPDIFF(MONTH,deadline,'2017-02-16');
- --该片段来自于http://www.codesnippet.cn/detail/2212201514255.html
来源: http://www.codesnippet.cn/detail/2212201514255.html