贴表结构及数据、要求结果出来看看 TRY: SELECT * FROM B1 UNION ALL SELECT * FROM B2 ORDER BY zxtime DESC
出错提示 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 'form user union all SELECT * FROM userr ORDER BY cs_zxtime desc' at line 1
SELECT * FROM ( SELECT * FROM B1 UNION ALL SELECT * FROM B2 ) TT ORDER BY zxtime DESC
"SELECT * FROM (select * form user union all SELECT * FROM userr) tt ORDER BY cs_zxtime desc" 出错: 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 'form user union all SELECT * FROM userr) tt ORDER BY cs_zxtime desc' at line 1
是MYSQL?什么版本? 我在MYSQL5。.1。X下, 1楼代码没有问题
"select * from (select * from user union all select * from userr) t order by cs_zxtime desc"
"SELECT * FROM (select * form->from user union all SELECT * FROM userr) tt ORDER BY cs_zxtime desc"
Illegal mix of collations for operation 'UNION' /zaixianshijianphb.asp,行 60 这个错误是什么意思啊
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005' [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Illegal mix of collations for operation 'UNION' /zaixianshijianphb.asp,行 60
你两表的字符集不一样。 show create table 看一下。
两表字符集不统一, show create table b1 show create table b2
SELECT * FROM (select * from user union all SELECT * FROM userr) tt ORDER BY cs_zxtime descSELECT * FROM (select * from user union all SELECT * FROM userr) t ORDER BY cs_zxtime descSELECT * FROM B1 UNION ALL SELECT * FROM B2 ORDER BY zxtime DESC 三个都对,这三个有什么区别,tt是什么意思:
TRY:
SELECT * FROM B1
UNION ALL
SELECT * FROM B2
ORDER BY zxtime DESC
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 'form user union all SELECT * FROM userr ORDER BY cs_zxtime desc' at line 1
SELECT * FROM B1
UNION ALL
SELECT * FROM B2 ) TT
ORDER BY zxtime DESC
出错:
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 'form user union all SELECT * FROM userr) tt ORDER BY cs_zxtime desc' at line 1
我在MYSQL5。.1。X下,
1楼代码没有问题
这个错误是什么意思啊
show create table 看一下。
show create table b1
show create table b2
UNION ALL
SELECT * FROM B2
ORDER BY zxtime DESC
三个都对,这三个有什么区别,tt是什么意思:
对delphi编程有研究没,有个问题想请教下