MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: alter table add colum if not exist
Posted by: Paul McArdle
Date: June 30, 2005 05:46AM

you could look at the mysql or information_shema table's.
write a script to see if the col exists for the database & table
creat col basted on that.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
alter table add colum if not exist
Mercier Raymond
June 30, 2005 02:29AM
Re: alter table add colum if not exist
Paul McArdle
June 30, 2005 05:46AM
Re: alter table add colum if not exist
Mercier Raymond
June 30, 2005 07:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.