Re: ALTER Table ....

[Göran Pettersson]

Hi again.

What I more particular want to do is as follows.

A/
I want to check if 'colA' exist in 'myTable', and if not then add this column.
Something like:
if 'colA' not exist then ALTER TABLE `messages` ADD `colA` FLOAT

Is this possible, and how is the correct syntax then ??

B/
If it's possible, as described above, can I then test and add multipel columns ?

Thanks in advance

Göran P