如何在MYSQL中实现这条SQL mysql不支持子查询,只能用两条查询来实现select max(id) from account;若id为123456delete * from account where id=123456; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 delete from account order by id DESC limit 1;这样子可以 , 以下是 4.0.17的验证mysql> select * from table1;+------------+------+------+| mydate | b | c |+------------+------+------+| 2004-05-01 | aaa4 | 2 || 2004-06-05 | a1 | 10 || 2004-06-21 | bb | 8 || 2004-06-07 | bb2 | 1 |+------------+------+------+4 rows in set (0.00 sec)mysql> delete from table1 order by c desc limit 1;Query OK, 1 row affected (0.00 sec)mysql> select * from table1;+------------+------+------+| mydate | b | c |+------------+------+------+| 2004-05-01 | aaa4 | 2 || 2004-06-21 | bb | 8 || 2004-06-07 | bb2 | 1 |+------------+------+------+3 rows in set (0.00 sec) 或者创建一个临时表,不过这样就比较麻烦了。seakingx的方法很好~~ :) 求一个SQL语句 mysql call的用法 服务器的数据库突然坏了,进不了,是什么问题 windows下mysqldump存储过程的问题 救命问题:是关于MySql启动时报错??急急急啊 求教两句sql语句,谢谢 一个库里表多了,对mysql的性能是不是很有影响 mysqldump着急阿.....在线!!!!!!!!!!! 社工库中的密码都是一堆数字和字母 小白安装Mysql求助~QAQ phpMyAdmin 设置的密码与 SHELL下命令式设置的密码有何不同? 在postgres数据库中,如果在一张表里,随机取出5条记录?
+------------+------+------+
| mydate | b | c |
+------------+------+------+
| 2004-05-01 | aaa4 | 2 |
| 2004-06-05 | a1 | 10 |
| 2004-06-21 | bb | 8 |
| 2004-06-07 | bb2 | 1 |
+------------+------+------+
4 rows in set (0.00 sec)mysql> delete from table1 order by c desc limit 1;
Query OK, 1 row affected (0.00 sec)mysql> select * from table1;
+------------+------+------+
| mydate | b | c |
+------------+------+------+
| 2004-05-01 | aaa4 | 2 |
| 2004-06-21 | bb | 8 |
| 2004-06-07 | bb2 | 1 |
+------------+------+------+
3 rows in set (0.00 sec)
seakingx的方法很好~~
:)