使用mysql workbench为表添加新列时“ALTER”语句报错
报错信息:Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘tbl_employee add column (d_id) int(11)’ at line 1
sql语句的表名需要写在``中,即
ALTER TABLE `tbl_employee` ADD COLUMN d_id INT(11);