MySQL Lists: mysql: add a column if not exists

List:	General Discussion	« Previous Message Next Message »
From:	Claire Lee	Date:	September 26 2005 4:44pm
Subject:	add a column if not exists
View as plain text

I want to check if a column exists in a table before I
do an alter table to add it. How do I do this in
mysql? Thanks.

Claire

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

Thread
• add a column if not exists	Claire Lee	26 Sep
• Re: add a column if not exists	Peter Brawley	26 Sep
• Re: add a column if not exists	Pooly	26 Sep
• Re: add a column if not exists	Gleb Paharenko	27 Sep