2021年1月15日
MySql查询当天、本周、本月、本季度、本年的数据
摘要： 1.今天 SELECT * FROM 表名 WHERE TO_DAYS(时间字段名) = TO_DAYS(NOW()); 2.昨天 SELECT * FROM 表名 WHERE TO_DAYS(NOW()) - TO_DAYS(时间字段名) <= 1; 3.本周 SELECT * FROM 表名 W 阅读全文
posted @ 2021-01-15 02:33 King-DA 阅读(687) 评论(0) 推荐(0)
SQL 经典练习题 + 答案
摘要： 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 阅读全文
posted @ 2021-01-15 02:27 King-DA 阅读(588) 评论(0) 推荐(0)
报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
摘要： [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 阅读全文
posted @ 2021-01-15 00:12 King-DA 阅读(780) 评论(0) 推荐(0)