MySQL修改表結(jié)構(gòu)及其添加刪除修改字段功能

MySQL修改表結(jié)構(gòu)及其添加刪除修改字段功能

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)聲明
THE END
喜歡就支持一下吧
點(diǎn)贊6 分享