mysql修改表結(jié)構(gòu)添加刪除修改字段
創(chuàng)建數(shù)據(jù)庫
CREATE?DATABASE?database_name
? ?
創(chuàng)建表
CREATE?TABLE?`user`?( ??`id`?int(11)?unsigned?NOT?NULL?AUTO_INCREMENT?COMMENT?'ID', ??PRIMARY?KEY?(`id`) )?ENGINE=MyISAM?DEFAULT?CHARSET=utf8;
? ?
刪除表
DROP?TABLE?IF?EXISTS?`user`;
? ?
添加字段:
"ALTER?TABLE??`user`?ADD??`id`?int(11)?NOT?NULL?DEFAULT?'0'??COMMENT?'ID'" ALTER??TABLE??`user`??ADD??`name`?VARCHAR(?20??)??CHARACTER??SET?utf8?COLLATE?utf8_general_ci?NULL??DEFAULT?NULL??COMMENT??'姓名'
? ?
刪除字段
ALTER?TABLE??`user`?DROP?column?name
? ?
? 重命名
ALTER?TABLE?table_name?CHANGE?old_field_name?new_field_name?field_type;
修改類型? ?
alter?table?t1?change?b?b?bigint?not?null;?? alter?table?infos?change?list?list?tinyint?not?null?default?'0';
? ?
加索引
alter?table?t1?rename?t2; mysql>?alter?table?tablename?change?depno?depno?int(5)?not?null;?? mysql>?alter?table?tablename?add?index?索引名?(字段名1[,字段名2?…]);?? mysql>?alter?table?tablename?add?index?emp_name?(name);加主關(guān)鍵字的索引?? mysql>?alter?table?tablename?add?primary?key(id);加唯一限制條件的索引?? mysql>?alter?table?tablename?add?unique?emp_name2(cardnumber);刪除某個(gè)索引?? mysql>alter?table?tablename?drop?index?emp_name;修改表:
? ?
Thinkphp3.2中添加字段,如:
M('admin')->execute("ALTER?TABLE??`admin`?ADD??`id`?int(11)?NOT?NULL?DEFAULT?'0'??COMMENT?'ID'"); M('admin')->execute("ALTER?TABLE??`admin`?ADD??`name`?varchar(20)?DEFAULT?NULL??COMMENT?'姓名'");
? 推薦教程:《Mysql》
? 版權(quán)聲明
文章版權(quán)歸作者所有,未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END