สร้างคำสั่ง CREATE TABLE จากตารางที่มีอยู่แล้วใน MySQL

ใช้ SHOW CREATE TABLE ไวยากรณ์:

SHOW CREATE TABLE yourTableName;

สร้างตารางตัวอย่าง:

mysql> create table StudentInformation ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentName varchar(20), StudentAge int DEFAULT 18, StudentRollNo int, StudentAddress varchar(200), StudentMarks int, StudentDOB datetime, StudentAdmissionDate datetime ); Query OK, 0 rows affected (0.54 sec)

สร้างคำสั่ง CREATE TABLE จากตารางที่มีอยู่:

mysql> SHOW CREATE TABLE StudentInformation;

ผลลัพธ์:

+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | StudentInformation | CREATE TABLE `studentinformation` ( `StudentId` int(11) NOT NULL AUTO_INCREMENT, `StudentName` varchar(20) DEFAULT NULL, `StudentAge` int(11) DEFAULT '18', `StudentRollNo` int(11) DEFAULT NULL, `StudentAddress` varchar(200) DEFAULT NULL, `StudentMarks` int(11) DEFAULT NULL, `StudentDOB` datetime DEFAULT NULL, `StudentAdmissionDate` datetime DEFAULT NULL, PRIMARY KEY (`StudentId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | +--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.04 sec)