Add column if not exists mysql

-- ALTER TABLE tbl_name ADD COLUMN column_name column_definition 
--		[FIRST|AFTER existing_column];
ALTER TABLE office ADD COLUMN phone VARCHAR(200) DEFAULT '000' AFTER name;
ALTER TABLE office ADD COLUMN flag INT(1) FIRST;
ALTER TABLE office ADD COLUMN last_col INT(2);	-- Last column is default position
-- ↓ Test it (Fiddle)

Source: sqlfiddle.com

Add column if not exists mysql

SELECT count(*) INTO @EXIST
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mydatabase'
  AND COLUMN_NAME = 'mycolumn'
  AND TABLE_NAME = 'mytable' LIMIT 1;

SET @query = IF (@exist <= 0, 'ALTER TABLE mydatabase.`mytable`  ADD COLUMN `mycolumn` MEDIUMTEXT NULL',
    'select \' COLUMN EXISTS\' status');
PREPARE stmt FROM @query;
EXECUTE stmt;

Source: dba.stackexchange.com

Similar codes

6 votes150 views2 answers
Insert into select mysql
SQL
0 vote144 views1 answer
What does leave do in mysql
SQL
1 vote145 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
4 votes141 views2 answers
Mysql show indexes on table
SQL
6 votes141 views2 answers
Mysql execute file
SQL
0 vote145 views1 answer
Mysql pad zeros
SQL
0 vote132 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote165 views1 answer
How to get data from 2 database
SQL
1 vote137 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote133 views1 answer
Best way to bind parameters to SqlCommand C#
SQL