This article mainly introduces the MySQL knowledge points of the second-level computer examination in detail, and introduces in detail the use of the alter command in mysql. It has certain reference value. Interested friends can refer to it
The usage of alter command in mysql is used to edit the table structure. The specific content is as follows
Modify field type
mysql> alter table employee change depno depno int(5) not null;
Add index
mysql> alter table 表名 add index 索引名 (字段名1[，字段名2 …]);
Example:
mysql> alter table employee add index emp_name (name);
Add the index of the primary keyword
##
mysql> alter table 表名 add primary key (字段名);
mysql> alter table employee add primary key(id);
mysql> alter table 表名 add unique 索引名 (字段名);
mysql> alter table employee add unique emp_name2(cardnumber);
mysql> show index from 表名;
mysql> show index from employee;
mysql> alter table 表名 drop index 索引名;
mysql>alter table employee drop index emp_name;
##
mysql> ALTER TABLE table_name ADD field_name field_type;
mysql> SELECT * FROM table_name;
mysql> ALTER TABLE table_name CHANGE old_field_name new_field_name field_type;
ALTER TABLE table_name DROP field_name
The above is the detailed content of Detailed explanation on the use of alter command in mysql. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
