SELECT * FROM 111 a,222 b WHERE b.vuid>0 and to_days(time())<(to_days(b.stime)+b.vday)出现错误:
#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 '))<(to_days(b.stime)+b.vday) LIMIT 0, 30' at line 1请问如何修改?
#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 '))<(to_days(b.stime)+b.vday) LIMIT 0, 30' at line 1请问如何修改?
运行后显示错误:
#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 'ays(b.stime)+b.vday) LIMIT 0, 30' at line 1
'截至2011-09-21 21:03:20 用户结帖率0.00% 当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖
uid vip
1 0
... 0
62 1
表222的内容:
vuid stime vday vtime
2 1315202122 5 2011-09-05 13:55:22
494 1315203433 10 2011-09-05 14:17:13
62 1315241722 31 2011-09-05 09:30:22
http://topic.csdn.net/u/20110921/15/83c29c82-e8a2-4d53-a1d0-e7496078ceda.html?seed=638337907&r=75645924