很抱歉,昨天问题没说清楚。 ID int(10) unsigned auto_increment 新闻ID TITLE varchar(100) 新闻标题 TYPE varchar(20) 新闻类型 TEXT mediumtext 内容 AUTHOR varchar(20) 作者 DATE varchar(20) 日期 VIEWNUM int(11) 点击次数 SOURCE varchar(100) 来源A和B是两个不同的网站的后台数据库,news1和news2两个表的结构完全相同,现在我想在PHP中将两个表的内容order by DATE 全部显示在一个表格中。
CREATE TEMPORARY TABLE tmp SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1'; INSERT INTO tmp SELECT field1_index, field2_index FROM test_table WHERE field2_index = '1'; SELECT * from tmp; DROP TABLE tmp;
很简单的insert,SELECT a,b,c into tmpa FROM [A].[news1] INSERT INTO tmpa SELECT a,b,c FROM [B].[news1] ok你select * from tmpa就ok了
Selec id,title,type,text,author,date,viewnum,source From A.dbo.news1 union Select news_id,title,type,text,author,date,viewnum,source From B.dbo.news2
SELECT * FROM A UNION SELECT * FROM B
我按照 AppleBBS(Dicky)的说法,出现了这样的错误: The used SELECT statements have a different number of columns
两个库的问题很难用一条sql解决, 但可以应用xml来实现,但前提是只做查询,没有插入修改的需求
//////////我按照 AppleBBS(Dicky)的说法,出现了这样的错误: The used SELECT statements have a different number of columns/////////different number of columns已经很明确了!,用union,各个select中的列数应相等.
select ID,TITLE,TYPE,EXT,AUTHOR,DATE,VIEWNUM,SOURCE from A.news1 union select ID,TITLE,TYPE,EXT,AUTHOR,DATE,VIEWNUM,SOURCE from B.news2 order by DATE
推薦用 : xuzuning(唠叨) 的select ID,TITLE,TYPE,EXT,AUTHOR,DATE,VIEWNUM,SOURCE from A.news1 union select ID,TITLE,TYPE,EXT,AUTHOR,DATE,VIEWNUM,SOURCE from B.news2 order by DATE --------------------
你条件都不说,谁帮你啊,我们不是免费sql工具吧,呵呵
查询完成数据库A中的news1再查数据库B中的news2表
ID int(10) unsigned auto_increment 新闻ID
TITLE varchar(100) 新闻标题
TYPE varchar(20) 新闻类型
TEXT mediumtext 内容
AUTHOR varchar(20) 作者
DATE varchar(20) 日期
VIEWNUM int(11) 点击次数
SOURCE varchar(100) 来源A和B是两个不同的网站的后台数据库,news1和news2两个表的结构完全相同,现在我想在PHP中将两个表的内容order by DATE 全部显示在一个表格中。
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1';
INSERT INTO tmp
SELECT field1_index, field2_index FROM test_table WHERE field2_index = '1';
SELECT * from tmp;
DROP TABLE tmp;
分别连接A、B两库导出.sql文件,然后利用.sql文件再导入一个临时表。这样肯定没问题。“笨方法” ^^
INSERT INTO tmpa
SELECT a,b,c FROM [B].[news1]
ok你select * from tmpa就ok了
FROM A
UNION SELECT *
FROM B
The used SELECT statements have a different number of columns
但可以应用xml来实现,但前提是只做查询,没有插入修改的需求
The used SELECT statements have a different number of columns/////////different number of columns已经很明确了!,用union,各个select中的列数应相等.
union
select ID,TITLE,TYPE,EXT,AUTHOR,DATE,VIEWNUM,SOURCE from B.news2
order by DATE
union
select ID,TITLE,TYPE,EXT,AUTHOR,DATE,VIEWNUM,SOURCE from B.news2
order by DATE
--------------------