alter query in mysql code example

Example 1: sql add column

ALTER TABLE Customers
ADD Email varchar(255);

Example 2: update query in mysql

-- Set New Employee Password 
UPDATE employee
SET employee.password = '1234'
WHERE employee.email = '[email protected]';

Example 3: change data type in mysql

ALTER TABLE table_name

CHANGE COLUMN column_name column_name datatype;