CREATE PROCEDURE AddColumnsIfNotExists() BEGIN — Alter table TOV_NotificationTest column isDeleted if not exists (select COLUMN_NAME from information_schema.columns where table_name=’pratice.address’ and COLUMN_NAME =’isDeleted’ and TABLE_SCHEMA = SCHEMA()) then alter table `address` add column `isDeleted` boolean default false; end if; END; why does if not exist is not working ? it is working fine in mySql workbench […]