SET @dbname = DATABASE(); SET @tablename = 'YourTable'; SET @columnname = 'YourColumn'; SET @columntype = 'YourType' -- Example: CHAR(16) binary; SET @command = (SELECT IF( ( SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE (table_name = @tablename) AND (table_schema = @dbname) AND (column_name = @columnname) ) > 0, "SELECT 1", CONCAT("ALTER TABLE ", @tablename, " ADD ", @columnname, " ", @columntype, " ;") )); PREPARE stmt FROM @command; EXECUTE stmt; DEALLOCATE PREPARE stmt;
Add column if not exists in MySQL
![](https://studyraft.com/wp-content/uploads/2022/04/1024px-MySQL.ff87215b43fd7292af172e2a5d9b844217262571-300x155.png)