show create table query of table in mysql
Copied mysql> SHOW CREATE TABLE t\G
*************************** 1. row ***************************
Table: t
Create Table: CREATE TABLE `t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`s` char(60) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
4.5
2
SHOW CREATE TABLE tablename
Thank you!
2
0
Are there any code examples left?
New code examples in category SQL