MySql~表结构的修改(使用alter实现字段的增删改)、对比modify与change的区别

1 row in set (0.01 sec)

mysql> alter table stu rename student;

Query OK, 0 rows affected (0.06 sec)

mysql> show tables;

±--------------------+

| Tables_in_java_7_22 |

±--------------------+

| student |

±--------------------+

1 row in set (0.00 sec)

show查询表的详细结构

===========================================================================

mysql> show create table stu \G;

*************************** 1. row ***************************

Table: stu

Create Table: CREATE TABLE stu (

id int(11) NOT NULL AUTO_INCREMENT,

name varchar(30) NOT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

ERROR:

No query specified

mysql>

modify修改字段类型和约束

==============================================================================

mysql> alter table stu modify name varchar(20);

Query OK, 0 rows affected (0.14 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> desc stu;

±------±------------±-----±----±--------±-----