From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 5:57 PM
To: hong chen
Subject: RE: create tmp table of column list of a table for future use
SHOW CREATE TABLE ... syntax will show you whether or not the field name
-Original Message-
From: hong chen
Sent: Friday, April 05, 2002 5:50 PM
To: 'Gurhan Ozen'
Subject: RE: create tmp table of column list of a table for future use
I am trying to check if a certain column exists before I try to select it from the
table.
in Oracle or Sql Serv
EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 5:13 PM
To: [EMAIL PROTECTED]
Subject: create tmp table of column list of a table for future use
mysql> create table column_list (desc MYTABLE_NAME);
ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)'
at line 1
Anyon
-Original Message-
From: hong chen
Sent: Friday, April 05, 2002 5:32 PM
To: 'Alex Behrens'
Subject: RE: create tmp table of column list of a table for future use
No luck. Oracle and Sql Server have system tables to check.
mysql> de
2-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: "hong chen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 4:13 PM
Subject: create tmp table of colum
mysql> create table column_list (desc MYTABLE_NAME);
ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1
Anyone know how to make something like it?
-
Before posting, please check:
http://www