$mysql->runSql("delete from music_user where did=( select max(did) from music_user)");;
表是music_user,找出did字段的最大值,然后将有最大值的行删除
像这条代码可以吗?
嗯 你的语句看起来是没问题的 可惜mysql 不支持这种写法
需要在查询里面再嵌套一个子查询
delete FROM music_user where did = ( select did from ( select max(did) as did from music_user) as tmp )
温馨提示:答案为网友推荐,仅供参考