34,875
社区成员
发帖
与我相关
我的任务
分享SQL作业中我这段代码有何错误？
我想utime和当前时间如果大于1分钟，就删除表users和permissions所有记录。
delete from users when datediff("n",utime,getdate())<=1;delete from permissions when datediff("n",utime,getdate())<=1;
但分析时出错：在关键字when附近有语法错误。
我不懂，只有请教各位了，谢谢！
delete from users when datediff("n",utime,getdate())<=1;delete from permissions when datediff("n",utime,getdate())<=1;
但分析时出错：在关键字when附近有语法错误。
我不懂，只有请教各位了，谢谢！
...全文
请发表友善的回复…
发表回复
datacomm 2003-09-27
- 打赏
- 举报
成功！只能用minute，不能用"n"
lshuy2001 2003-09-27
- 打赏
- 举报
你的users和permissions表中都有utime的字段么？
看样子是没有，如果都有的话那么就不应该有错误！
因为两个操作只是表的不同而已呀！
看样子是没有，如果都有的话那么就不应该有错误！
因为两个操作只是表的不同而已呀！
datacomm 2003-09-27
- 打赏
- 举报
有呀！utime字段是datetime类型。
伍子V5 2003-09-27
- 打赏
- 举报
你的permissions里有utime字段吗
伍子V5 2003-09-27
- 打赏
- 举报
delete from users where datediff("n",utime,getdate())<=1
delete from permissions where datediff("n",utime,getdate())<=1
delete from permissions where datediff("n",utime,getdate())<=1
datacomm 2003-09-27
- 打赏
- 举报
踏网无痕，怎么提示“为datediff指定了无效的参数1”？我只分析一条delete from users where datediff("n",utime,getdate())<=1。
yujohny 2003-09-27
- 打赏
- 举报
delete from users where datediff("n",utime,getdate())<=1
delete from permissions where datediff("n",utime,getdate())<=1
yujohny 2003-09-27
- 打赏
- 举报
delete from users where datediff(n,utime,getdate())<=1
delete from permissions where datediff(n,utime,getdate())<=1
delete from permissions where datediff(n,utime,getdate())<=1
jock_521 2003-09-27
- 打赏
- 举报
Up
