MySQL
Dreamer_GUO
程序狗一枚~向大神看齐!!!
展开
-
MySQL报错:Operand should contain 1 column(s)] with root cause
原SQL语句:select id, date, batch, worm_group, hatch_box_number, hatch_end_time, fhhlkfhw_weightfrom hwhere hatch_end_time is null and fhhlkfhw_weight is null and id in (select max(id) from h group by (batch, worm_group, hatch_box_number))修改:将grou原创 2021-04-30 18:02:14 · 1036 阅读 · 2 评论 -
MySQL查询当天日期所在周的周一的记录,格式转换
select * from table_namewhere date = (SELECT DATE_FORMAT(date_sub(curdate(),INTERVAL WEEKDAY(curdate()) DAY),'%Y/%m/%d'))原创 2021-04-19 13:06:56 · 135 阅读 · 0 评论 -
MySQL查询当天日期的记录,格式转换
select<include refid="Base_Column_List" />from table_namewhere date = (SELECT DATE_FORMAT(NOW(),'%Y/%m/%d'))原创 2021-04-15 15:19:26 · 151 阅读 · 0 评论