+----------------+-------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------------------+-------+ | UserID | varchar(10) | | PRI | | | | LastUpdateTime | datetime | | | 0000-00-00 00:00:00 | | +----------------+-------------+------+-----+---------------------+-------++--------+---------------------+ | UserID | LastUpdateTime | +--------+---------------------+ | 19038 | 2003-10-26 10:58:25 | | 19042 | 2001-10-10 10:10:10 | | 19041 | 2003-10-20 10:38:24 | | 11221 | 2000-01-01 12:00:00 | +--------+---------------------+ 表是这样的。输入 select TOP 5 UserID from user order by desc; 输出 ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near '5 UserID fro m user order by desc' at line 1。
select top 10 * from A order by B desc
还有就是数据库是My-Sql,偶好像发错地方了
select TOP 5 UserID from user order by UserID desc; 还是 select TOP 5 UserID from user order by LastUpdateTime desc;
go
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------------------+-------+
| UserID | varchar(10) | | PRI | | |
| LastUpdateTime | datetime | | | 0000-00-00 00:00:00 | |
+----------------+-------------+------+-----+---------------------+-------++--------+---------------------+
| UserID | LastUpdateTime |
+--------+---------------------+
| 19038 | 2003-10-26 10:58:25 |
| 19042 | 2001-10-10 10:10:10 |
| 19041 | 2003-10-20 10:38:24 |
| 11221 | 2000-01-01 12:00:00 |
+--------+---------------------+
表是这样的。输入 select TOP 5 UserID from user order by desc;
输出 ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '5 UserID fro
m user order by desc' at line 1。
还是
select TOP 5 UserID from user order by LastUpdateTime desc;