不好意思,ydage,我测试的时候没有用到time()这个函数,
我用这个命令:delete from 表名 where submitTime between '00:00:00' and '08:00:00'所以提示错误。
后来看到你的说明,,time(submitTime):取submitTime中的时间部分才明白你的意思,
不过我用delete from 表名 where time(submitTime) between '00:00:00' and '08:00:00',测试的时候,提示
time(submitTime)错误,我怀疑是time这个函数对于我这个MYSQL不支持,不过你给了我提示,我现在用
delete from consume where date_format(submitTime,'%T') between '00:00:00' and '08:00:00';