第一句: select * from t_table where NOT EXISTS (select * from t_table where id=1) 没有错后面的子句 select * from t_table w where t.keyword = w.keyword and w.posttime > t.posttime 表t是不是也应该在from后面有 select * from t_table,w,t
ERROR 1064: You have an error in your SQL syntax near 'EXISTS (select * from t_u sers where id=1)' at line 1
执行的是: select * from t_users where NOT EXISTS (select * from t_users where id=1)
是不是这样呢 select * from t_users where 字段名 NOT EXISTS (select 字段名 from t_users where id=1)
表之间要有逗号
select * from t_table where NOT EXISTS (select * from t_table where id=1)
没有错后面的子句
select * from t_table w where t.keyword = w.keyword and w.posttime > t.posttime
表t是不是也应该在from后面有
select * from t_table,w,t
sers where id=1)' at line 1
select * from t_users where NOT EXISTS (select * from t_users where id=1)
select * from t_users where 字段名 NOT EXISTS (select 字段名 from t_users where id=1)