SQL

mysql alter table add column

ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;

add new column to the table mysql

ALTER TABLE `TABLE_NAME` 
	ADD `COLUMN_NAME` VARCHAR(50) NULL
    AFTER `COLUMN_NAME_AFTER`;

alter table add column forigen key mysql

ALTER TABLE tryholpz_demo07.core_modules 
ADD COLUMN belongs_to_role INT, 
ADD FOREIGN KEY core_modules(belongs_to_role) REFERENCES role_specific_modules_info(id) ON DELETE CASCADE

mysql alter table add column first

-- 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)

mysql alter table add column

ALTER TABLE table ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];

mysql alter table add column

ALTER TABLE table
  ADD [COLUMN] column_name column_definition
  [FIRST|AFTER existing_column];

add column first position mysql

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)

add column to all tables after first column mysql

SELECT CONCAT('ALTER TABLE ', table_schema,'.', TABLE_NAME,' ADD COLUMN `hash` VARCHAR(50) NULL DEFAULT UUID() AFTER ', first_column, ';') AS ddl

FROM (

	SELECT
		(
			SELECT `COLUMN_NAME`
			FROM `INFORMATION_SCHEMA`.`COLUMNS`
			WHERE `TABLE_SCHEMA`=t.TABLE_SCHEMA AND `TABLE_NAME`=t.TABLE_NAME
			LIMIT 1
		) AS 'first_column',
		t.*
	FROM
	information_schema.tables t
	WHERE table_schema = 'your_table_name' AND table_type = 'base table'
	
) AS x;