select threadId from post Inner Join threads USING threadId where forumId=某个板块 order by buildDate desc limit 1
threadId where forumId=某个板块 order by buildDate desc limit 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 'thre dId where forumId = 1 order by buildDate desc' at line 1
show create table posts; show create table threads; show create table forums;把这三个的结果贴出来。
求 某个板块的最后一个回复的主题 select threadid from threads inner join forums on forums.forumId=threads.forumId inner join posts on posts.threadId =threads.threadId where forumId=100 order by posts.buildDate desc limit 1;
就是这样的: select threadId from post Inner Join threads USING threadId where forumId=某个板块 order by buildDate desc limit 1
我的显示有错误.. mysql> select threadId from bbs_posts inner join bbs_threads USING threadId wher e forumId = 1 order by buildDate desc; 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 'threa dId where forumId = 1 order by buildDate desc' at line 1
select threadId from post Inner Join threads USING (threadId) where forumId=某个板块 order by buildDate desc limit 1 忘了加上括号。
应为我的主体表也有buildDate,所以不能这么查询 mysql> select * from bbs_posts inner join bbs_threads USING (threadId) where for umId = 1 order by buildDate ; ERROR 1052 (23000): Column 'buildDate' in order clause is ambiguous
select * from threads as a left join posts as b on(a.threadId=b.threadId) where a.forumId=1某个版块 order by b.buildDate desc limit 1
from post Inner Join threads USING threadId
where forumId=某个板块
order by buildDate desc
limit 1
where forumId=某个板块
order by buildDate desc
limit 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 'thre
dId where forumId = 1 order by buildDate desc' at line 1
posts回复表 threads主题表 forums板块表
postId threadId forumId
threadId forumId
buildDate
show create table threads;
show create table forums;把这三个的结果贴出来。
select threadid from threads inner join forums on forums.forumId=threads.forumId
inner join posts on posts.threadId =threads.threadId
where forumId=100
order by posts.buildDate desc limit 1;
select threadId
from post Inner Join threads USING threadId
where forumId=某个板块
order by buildDate desc
limit 1
mysql> select threadId from bbs_posts inner join bbs_threads USING threadId wher
e forumId = 1 order by buildDate desc;
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 'threa
dId where forumId = 1 order by buildDate desc' at line 1
from post Inner Join threads USING (threadId)
where forumId=某个板块
order by buildDate desc
limit 1
忘了加上括号。
mysql> select * from bbs_posts inner join bbs_threads USING (threadId) where for
umId = 1 order by buildDate ;
ERROR 1052 (23000): Column 'buildDate' in order clause is ambiguous