数据库错误 MySQL #1064

错误
SQL 查询:  

SELECT username, (


SELECT COUNT( uid ) 
FROM pw_inviterecord
WHERE uid = a.uid
AND typeid =0
)visitnum, (

SELECT COUNT( uid ) 
FROM pw_inviterecord
WHERE uid = a.uid
AND typeid =1
)registernum, reward, unit, create_time, typeid typeid
FROM pw_inviterecord a
GROUP BY uid
ORDER BY create_time DESC 
LIMIT 0 , 20 

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 'SELECT COUNT(uid) FROM pw_inviterecord WHERE uid=a.uid and type

答案：oracle的优势在于功能丰富 支持多种平台，缺点是复杂，昂贵
sqlserver 支持的功能和平台要少很多， 有点是 相对简单 便宜

其他：)registernum, reward, unit, create_time, typeid typeid

两个typeid registernum, reward, unit, create_time, typeid typeid 提示说你参数有问题 ,你可以吧你上传的文件分开传不要超过2兆
 

上一个：centos 5.5 linux系统安装MYSQL数据库编译时出现错误 30分求解决
下一个：MySQL创建触发器实现统一主机下两个数据库的表同步