怎样写MySQL语句可以同时select两个field name 完全相同的表?譬如 databases test1 含有两个表 table1和table2,两个表fileld name及property完全相同。
>>>CREATE DATABASE test1;
>>>USE test1;>>>CREATE TABLE `test1`.`table1` (`id` INT( 9 ) NULL );
>>>INSERT INTO `test1`.`table1` (`id` )VALUES ('1');>>>CREATE TABLE `test1`.`table2` (`id` INT( 9 ) NULL );
>>>INSERT INTO `test1`.`table2` (`id` )VALUES ('8');如何写SQL语句一起查询两个表,理想结果应该是:id
1
8我刚学不久,不晓得表达清楚了没有,谢谢大家帮忙啊!
>>>CREATE DATABASE test1;
>>>USE test1;>>>CREATE TABLE `test1`.`table1` (`id` INT( 9 ) NULL );
>>>INSERT INTO `test1`.`table1` (`id` )VALUES ('1');>>>CREATE TABLE `test1`.`table2` (`id` INT( 9 ) NULL );
>>>INSERT INTO `test1`.`table2` (`id` )VALUES ('8');如何写SQL语句一起查询两个表,理想结果应该是:id
1
8我刚学不久,不晓得表达清楚了没有,谢谢大家帮忙啊!
UNION ALL
SELECT * FROM TEST2
UNION ALL
SELECT * FROM TEST2 就是这么滴。
union all
select id from table2
Query OK, 1 row affected (0.00 sec)mysql> USE test1;
Database changed
mysql>mysql> CREATE TABLE `test1`.`table1` (`id` INT( 9 ) NULL );
Query OK, 0 rows affected (0.02 sec)mysql> INSERT INTO `test1`.`table1` (`id` )VALUES ('1');
Query OK, 1 row affected (0.03 sec)mysql>
mysql> CREATE TABLE `test1`.`table2` (`id` INT( 9 ) NULL );
Query OK, 0 rows affected (0.02 sec)mysql> INSERT INTO `test1`.`table2` (`id` )VALUES ('8');
Query OK, 1 row affected (0.01 sec)mysql> select id from table1
-> union all
-> select id from table2;
+------+
| id |
+------+
| 1 |
| 8 |
+------+
2 rows in set (0.00 sec)mysql>