mysql>show tables;+------------------+
| Tables_in_course |
+------------------+
| course |
| dept |
| dept_bak |
| scores |
| students |
| students2 |
| students3 |
| students_tmp |
| teacher |
| teacher_backup |
| v_1 |
+------------------+
11 rows in set (0.01sec)
mysql>rename table students2 to students_bak;
Query OK,0 rows affected (0.11sec)
mysql>show tables;+------------------+
| Tables_in_course |
+------------------+
| course |
| dept |
| dept_bak |
| scores |
| students |
| students3 |
| students_bak |
| students_tmp |
| teacher |
| teacher_backup |
| v_1 |
+------------------+
11 rows in set (0.00sec)
mysql>show create table students_bak;+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| students_bak |CREATE TABLE `students_bak` (
`sid`int(11) NOT NULL DEFAULT '0',
`sname` varchar(64) DEFAULT NULL,
`gender` varchar(12) DEFAULT NULL,
`dept_id`int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01sec)
mysql>show create table students;+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| students |CREATE TABLE `students` (
`sid`int(11) NOT NULL AUTO_INCREMENT,
`sname` varchar(64) DEFAULT NULL,
`gender` varchar(12) DEFAULT NULL,
`dept_id`int(11) NOT NULL,
PRIMARY KEY (`sid`),
UNIQUE KEY `idx_1` (`sname`),
KEY `for_1` (`dept_id`),
KEY `idx_123` (`sid`,`sname`),
KEY `idx_124` (`sid`),
KEY `idx_126` (`sname`),
CONSTRAINT `for_1` FOREIGN KEY (`dept_id`) REFERENCES `dept` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00sec)
mysql>rename table dept to dept_2;
Query OK,0 rows affected (0.14sec)
mysql>show create table students;+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| students |CREATE TABLE `students` (
`sid`int(11) NOT NULL AUTO_INCREMENT,
`sname` varchar(64) DEFAULT NULL,
`gender` varchar(12) DEFAULT NULL,
`dept_id`int(11) NOT NULL,
PRIMARY KEY (`sid`),
UNIQUE KEY `idx_1` (`sname`),
KEY `for_1` (`dept_id`),
KEY `idx_123` (`sid`,`sname`),
KEY `idx_124` (`sid`),
KEY `idx_126` (`sname`),
CONSTRAINT `for_1` FOREIGN KEY (`dept_id`) REFERENCES `dept_2` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)