摘要：
1.今天 SELECT * FROM 表名 WHERE TO_DAYS(时间字段名) = TO_DAYS(NOW()); 2.昨天 SELECT * FROM 表名 WHERE TO_DAYS(NOW()) - TO_DAYS(时间字段名) <= 1; 3.本周 SELECT * FROM 表名 W 阅读全文
摘要：
CREATE SCHEMA exercise; USE exercise; CREATE TABLE Student ( stu_id VARCHAR(3) NOT NULL, stu_name VARCHAR(4) NOT NULL, stu_sex VARCHAR(2) NOT NULL, st 阅读全文
摘要：
[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'community.tab_order_goods.goods_name' which is 阅读全文