注册 登录
编程论坛 MySQL论坛

mysql用sql查询时的错误

梦里蓝天 发布于 2006-09-23 14:35, 1663 次点击

各位,不弟不明白,为什么在mysql中用sql语句查询select * from 'count' WHERE ip = '127.0.0.1'AND name= 'yifan1'
会出现这样的错误,
SQL 查询:

SELECT *
FROM 'count'
WHERE ip = '127.0.0.1'
AND name = 'yifan1'
LIMIT 0 , 30

MySQL 返回:

#1064 - 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 ''count' WHERE ip = '127.0.0.1' AND name = 'yifan1'
LIMIT 0, 30' at line 1

请各位赐教!!!!!

3 回复
#2
可可℃乐2006-09-24 14:49
select * from 'count' WHERE ip = '127.0.0.1'AND name= 'yifan1'
表名COUNT不需要加引号..
#3
heguangming2006-10-19 08:49
select * from [count] WHERE ip = '127.0.0.1'AND name= 'yifan1'
这样也应该可以
#4
梦里蓝天2006-10-24 14:49
谢谢大家啦
1