摘要:
按天 SELECT DATE_FORMAT(date,'%Y-%m-%d') as date_time,SUM(real_profit) as real_profit FROM t_w GROUP BY date_time; 按周:自然周SELECT DATE_FORMAT(date,'%Y-%u' 阅读全文
摘要:
蠕虫复制:(复制表数据):插入字段列不包含主键、唯一键,会冲突 不同表复制 INSERT INTO table_a SELECT * FROM table_b; INSERT INTO table_a(a,b) SELECT a,b FROM table_b where id=1; 同表复制 INS 阅读全文