我在mysql数据库中执行select top 1* from person;
提示ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '1* fr
om person' at line 1
提示ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '1* fr
om person' at line 1
解决方案 »
- 求教windows下mysql5.5设置autocommit问题
- MySQL性能问题,使用固定内存,占用过多CPU
- sqlserver mysql 存储过程转换
- mysql 内存溢出
- Mysql数据库还原之后,show tables 显示有表,select时抱错表不存在!
- 请高手帮我写一个简单的脚本,谢谢了!!
- 有谁购买过mysql的License
- 【求助】数据库检索分类性能问题
- mysql字符集问题.
- mysql5.6.16中怎么没有找到max_statement_time变量
- 慎用mysql-cluster
- 关于binlog_format=mixed时,什么时候使用row-based logging
select top 1 * from testTable;对应
MYSQL
select * from testTable limit 0,1;
select * from tableName limit 1;