删除表:test_roller中多余的字段cut_tag
SET @preparedStatement = (SELECT IF(
(
SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = DATABASE()
AND table_name = 'test_roller'
AND column_name = 'cut_tag'
) = 0,
'SELECT 1',
'ALTER TABLE test_roller DROP cut_tag'
));
PREPARE alterIfNotExists FROM @preparedStatement;
EXECUTE alterIfNotExists;
DEALLOCATE PREPARE alterIfNotExists;