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)
===========================================================================
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>
==============================================================================
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;
±------±------------±-----±----±--------±---------------&