Topic: Query - ALTER TABLE

[karimali831]

Hi,

When I use the below query:

Code: [Select]

mysql_query("ALTER TABLE `".PREFIX."settings`
    ADD `col2` INT(11) NOT NULL default '1' AFTER `col1`,
    ADD `col3` varchar(255) NOT NULL default 'irc.evolu.net' AFTER `col2`;")
OR die(PREFIX.'settings failed');
It will die even though I have col2 but not col3 (column)
So lets say I have column col2 and not column col3, how can I change the query to that it will add column 3 only?
So basically add what I don't have and never mind the columns that are already there.

Thanks for help

[karimali831]

no? you can not do this?

[karimali831]

 

[karimali831]

 

[Soldier Jane]

I've yet to learn properly how to do this, but I'm guessing it's something like:

mysql_query("ALTER tablename ADD col3 varchar (255) NOT NULL default 'irc.evolu.net' AFTER col2");

Might be a couple of mistakes in there but it's along the right lines at least.

[Illusion]

You want to have all that intelligence in single query, I think that's not possible.

[fenway]

Why would you even want to?