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:
-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 desc ATTRIBUTES
-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 Server I would
[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 is
there..
Gurhan