Hello,
Try this:
mysql> CREATE TABLE a (
id int NOT NULL PRIMARY KEY,
des varchar(20) default NULL
);
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO a VALUES (1,'pepe'),(2,'juan'),(3,'mariano');
Query OK, 3 rows affected (0.00 sec)
Registros: 3 Duplicados: 0 Peligros: 0
mysql> select NULL as id, des
-> from a
-> union
-> select id, des
-> from a;
+------+---------+
| id | des |
+------+---------+
| NULL | pepe |
| NULL | juan |
| NULL | mariano |
| | pepe |
| | juan |
| | mariano |
+------+---------+
6 rows in set (0.00 sec)
Is this OK? I think that no.
Then try this:
mysql> select id, des
-> from a
-> union
-> select NULL as id, des
-> from a;
+----+---------+
| id | des |
+----+---------+
| 1 | pepe |
| 2 | juan |
| 3 | mariano |
| 0 | mariano |
+----+---------+
4 rows in set (0.00 sec)
Is this OK? Again, I think that no.
Thanks,
José Ceferino Ortega
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
