-- 添加新列 ALTER TABLE users ADD COLUMN phone VARCHAR(20), ADD COLUMN address TEXT; -- 修改列定义 ALTER TABLE users MODIFY COLUMN email VARCHAR(300) NOT NULL; -- 删除列 ALTER TABLE users DROP COLUMN address;