修改表名
ALTER table old_name rename to new_name
例:
ALTER table users rename to qq_name;
修改字段名
ALTER table table_name
CHANGE old_name new_name type
例:
ALTER table games
change gno game_id varchar(20);
修改字段数据类型
ALTER table table_name
MODIFY gno varchar(20);
添加字段
ALTER table table_name
add gno varchar(20);
删除字段
ALTER table table_name
drop gno;
添加约束
ALTER TABLE table_name
add constraint pk_users_userid
PRIMARY KEY(userid)
添加外键约束
ALTER table F_table
add constraint con_name
foreign key (f_col) references m_table(m_col)
alter table scores
add constraint fk_scores_games
foreign key(gno) references games(gno)
添加检查约束
ALTER table table_name
add constraint con_name
check(exp)
例:
ALTER table games
add constraint ck_games_gno
check(gno>0)
添加默认值
ALTER table table_name
alter col_name set default value
例:
ALTER table users
alter user_sex set default ‘男’
添加自增
ALTER table table_name
MODIFY colum col_name … AUTO_INCREMENT
例:
ALTER table ‘GAMES’
MODIFY COLUMN ‘GNO’ INT NOT NULL AUTO_INCREMENT
PRIMARY KEY