[MySQL] IF WHERE conditions correct syntax

Dragokas · **Author**

Hi,

help me please compile correct mysql syntax.

I tried:

Code:

ALTER TABLE `l4d2_stats_test` ADD COLUMN `Dummy` int(11) NOT NULL DEFAULT '0' AFTER `Boomer`
WHERE (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'l4d2_stats_test' AND column_name = 'Dummy') = 0;

and

Code:

IF (
  0 = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'l4d2_stats_test' AND column_name = 'Boomer')
)
begin
  ALTER TABLE `l4d2_stats_test` ADD COLUMN `Dummy` int(11) NOT NULL DEFAULT '0' AFTER `Boomer`;
end;

both unsuccessful (incorrect syntax).

Thanks.