请原谅我制定适当头衔的能力。
我有一个带有列的表:
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| name | char(20) | YES | | NULL | |
| pri | int(11) | YES | | NULL | |
| sec | int(11) | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
像这样的数据
+--------+------+------+
| name | pri | sec |
+--------+------+------+
| first | 1 | 2 |
| second | 3 | 4 |
| third | 5 | 6 |
+--------+------+------+
我想要一个可以给出结果的选择:
+--------+------+
| name | addr |
+--------+------+
| first | 1 |
| first | 2 |
| second | 3 |
| second | 4 |
| third | 5 |
| third | 6 |
+--------+------+
任何帮助,将不胜感激。
尝试这个
SELECT name, pri AS addr
FROM Table1
WHERE pri is NOT NULL
UNION ALL
SELECT name, sec AS addr
FROM Table1
WHERE sec is NOT NULL
order by 1,2
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句