Bug #2531 IF NOT EXISTS while altering TABLE
Submitted: 27 Jan 2004 3:23 Modified: 7 Oct 2005 22:37
Reporter: Dhaval Lodhia Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version: OS:
Assigned to: CPU Architecture:Any

[27 Jan 2004 3:23] Dhaval Lodhia 
Description:
Hi guys,

I can see mysql is really booming up, if we have some more features, which other database dont give, it would be really gr8. Something like, if exists, as we have while creating table, we can use "IF NOT EXITS", can we have similar functionality while altering the TABLE ..can we know if a particular column exits or not ?

Anyhow, mysql is the best

How to repeat:
Repeat like this?Hi guys,

I can see mysql is really booming up, if we have some more features, which other database dont give, it would be really gr8. Something like, if exists, as we have while creating table, we can use "IF NOT EXITS", can we have similar functionality while altering the TABLE ..can we know if a particular column exits or not ?

Anyhow, mysql is the best
[7 Oct 2005 22:37] Hartmut Holzgraefe 
Bug #3706 is actually a duplicate of this one but goes a bit more into detail,
so i'm closing this one as duplicate of 3706 now