In a siutation like this:
mysql> create table t1 (one int, two int);
Query OK, 0 rows affected (0.08 sec)
mysql> create table t2 (one int, two int);
Query OK, 0 rows affected (0.09 sec)
mysql> insert into t1 values (1, 2);
Query OK, 1 row affected (0.08 sec)
mysql> insert into t2 values (1, 2);
Query OK, 1 row affected (0.08 sec)
mysql> select t1.*, t2.* from t1, t2;
+------+------+------+------+
| one | two | one | two |
+------+------+------+------+
| 1 | 2 | 1 | 2 |
+------+------+------+------+
1 row in set (0.08 sec)
mysql> select * from t1, t2;
+------+------+------+------+
| one | two | one | two |
+------+------+------+------+
| 1 | 2 | 1 | 2 |
+------+------+------+------+
1 row in set (0.08 sec)
Is there a way to make MySQL spit back the column names qualified with
their table names, like:
| t1.one | t1.two | t2.one | t2.two |
If I missed the obvious, please feel free to point that out. :-)
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 113 days, processed 322,308,662 queries (32/sec. avg)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
