what I'm trying to do is for sql to check and see if a column missing, if it is then i want sql to create the column. I've done several attempts with no luck. the alter table add column sql works but it fails when i add it to the if condition.
any thoughts?
CREATE PROCEDURE addcol() BEGIN
IF NOT EXISTS(
SELECT * FROM information_schema.COLUMNS
WHERE COLUMN_NAME="new_column" AND TABLE_NAME="transform_data_1"
)
THEN
ALTER TABLE `transform_data_1`
ADD COLUMN `type` INT NOT NULL
END IF
//
CALL addcol();
DROP PROCEDURE addcol;