摘要:
思路:把两个表的数据按日期整合到临时表在按日期分组,求和。 例子: SELECT t.dateTime AS '日期',SUM(t.money) AS '表1利息',SUM(t.interest) AS '表2利息' FROM(SELECT DATE_FORMAT(date,'%Y-%m-%d') 阅读全文
摘要:
SELECT INSERT(mobile, 4, 4, '****')AS Mobile from Users ; SELECT STUFF(Mobile ,4,4,'***') AS Mobile from Users ; 阅读全文