ALTER TABLE CHECKING

moooon · May 4th, 2006, 10:24 PM

I have following query :

Code:

alter table table_member add temp1234 int(10);

How can i enhance it by the checking field/column `temp1234` existence before perform alter table?

milind.paralkar · May 5th, 2006, 12:09 AM

Hello moooon,

I don't know which mysql version you are using.
In version 5.1.7-beta-log , database "INFORMATION_SCHEMA" has been provided.
Information_schema contain table "COLUMNS".
See using..
mysql> desc columns; // for more details
Now you can make simple select statement which will provide you the info like
which column is/are in which table. Your statement.....

mysql> SELECT table_name,column_name
FROM COLUMNS
WHERE table_name LIKE 'table_member%';

Regards
MILIND

moooon · May 5th, 2006, 01:56 AM

Hi MILIND
Thanks alot!
That is very helpful.
Regards,