* oe-ander > How do i check if a column(name) do not exists in a table before i add it? > Like: alter table fruit add aple varchar(20) not null if aple do not exists
As far as I can see, you have two options: - Do a "describe fruit", and check the "Field" column - Do the "alter table...", and check for a error msg The second method is probably best, because you can not be sure if someone have added the column after you do a "describe fruit", but before you do your "alter table...". -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php