数据库：字段管理

字段管理:

---

创建新表

CREATE TABLE `myweb`.`user123`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user` varchar(255) NOT NULL,
  `age` int(0) NOT NULL,
  PRIMARY KEY (`id`)
);

1.添加字段

alter table user add age tinyint unsigned not null;
alter table user add pass varchar(30) not null after user;
alter table user add pass varchar(30) not null first;
在ID前面添加字段

ALTER TABLE `myweb`.`user` 
ADD COLUMN `age` int(0) NULL FIRST;

在id后面添加字段

ALTER TABLE `myweb`.`user` 
ADD COLUMN `age` int(0) NULL AFTER `id`;

2.删除字段

alter table user drop password;

ALTER TABLE `myweb`.`user123` 
DROP COLUMN `age`;

3.修改字段

alter table user modify username varchar(30) not null;
alter table user change username user varchar(30) not null;

ALTER TABLE `myweb`.`user123` 
CHANGE COLUMN `age` `sex` int(11) NOT NULL AFTER `user`;

4.查看字段

desc user;

desc user123;