Renaming a Table
|
|
|
/*
mysql> CREATE TABLE student (
-> id INT NOT NULL AUTO_INCREMENT,
-> name VARCHAR (50),
-> email VARCHAR (50),
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected (0.05 sec)
mysql> Show tables;
+-------------+
| Tables_in_t |
+-------------+
| bird |
| cloth |
| employee |
| event |
| man |
| person |
| report |
| sales |
| shirt |
| student |
| timetable |
+-------------+
11 rows in set (0.01 sec)
mysql> /* Renaming a Table */
mysql> ALTER TABLE student RENAME MyUsers;
Query OK, 0 rows affected (0.01 sec)
mysql> Show tables;
+-------------+
| Tables_in_t |
+-------------+
| bird |
| cloth |
| employee |
| event |
| man |
| myusers |
| person |
| report |
| sales |
| shirt |
| timetable |
+-------------+
11 rows in set (0.01 sec)
*/
Drop TABLE student;
CREATE TABLE student (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR (50),
email VARCHAR (50),
PRIMARY KEY (id)
);
Show tables;
/* Renaming a Table */
ALTER TABLE student RENAME MyUsers;
Show tables;
|
|
|
|
|
|
|
