Study/MySQL2022. 3. 23. 14:24

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;

Posted by 굥쓰
[P] Download2021. 5. 31. 10:46
Posted by 굥쓰
Study/Bookmark2021. 4. 7. 11:49