SELECT count(*) INTO @EXIST
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'column_name'
AND TABLE_NAME = 'table_name' LIMIT 1;
SET @query = IF (@EXIST<= 0, 'ALTER TABLE `table_name` ADD COLUMN `column_name` VARCHAR(100) NULL AFTER `isPublic`',
'select \'column_name COLUMN EXISTS\' status');
PREPARE stmt FROM @query;
EXECUTE stmt;
'add_column'에 해당되는 글 1건
- 2022.03.23 Add Column if not exists
Study/MySQL2022. 3. 23. 14:24
