Results 1 to 2 of 2
Jun 5, 2007, 05:32 #1
perform alter table only if a table exists
I need to run a batch of "Alter table" statements on a set of database tables.
However, some of the databases may not exist, and even if they exist, the specific table might not exist.
Alter table only works if the table exists.
Is there a way to tell MySQL to execute the "Alter table" statement only if the database and table exist?
If so, how?
Jun 5, 2007, 05:59 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 52 Post(s)
- 2 Thread(s)