mysql> SHOW CREATE TABLEteacher;+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| teacher | CREATE TABLE`teacher` (
`id`int(11) NOT NULLAUTO_INCREMENT,
`name`varchar(30) DEFAULT NULL,
`course_id`int(11) NOT NULL,PRIMARY KEY(`id`),UNIQUE KEY`index_teacher_id_unique` (`id`),UNIQUE KEY `index_teacher_id_comment` (`id`) COMMENT '这就是创建一个唯一索引而已!',KEY`teacher_course` (`course_id`),KEY`index_teacher_id` (`id`),KEY`index_teacher_id_and_name` (`id`,`name`),CONSTRAINT `teacher_course` FOREIGN KEY (`course_id`) REFERENCES`course` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 |
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00sec)
mysql>mysql> DROP INDEX index_teacher_id_and_name ONteacher;
Query OK,0 rows affected (0.01sec)
Records:0 Duplicates: 0 Warnings: 0mysql>mysql> SHOW CREATE TABLEteacher;+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| teacher | CREATE TABLE`teacher` (
`id`int(11) NOT NULLAUTO_INCREMENT,
`name`varchar(30) DEFAULT NULL,
`course_id`int(11) NOT NULL,PRIMARY KEY(`id`),UNIQUE KEY`index_teacher_id_unique` (`id`),UNIQUE KEY `index_teacher_id_comment` (`id`) COMMENT '这就是创建一个唯一索引而已!',KEY`teacher_course` (`course_id`),KEY`index_teacher_id` (`id`),CONSTRAINT `teacher_course` FOREIGN KEY (`course_id`) REFERENCES`course` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00sec)
mysql>
转播
