No cache version.

Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.

Rechercher dans le manuel MySQL

13.7.6.10 SHOW CREATE TABLE Syntax

Contents
  1. SHOW CREATE TABLE tbl_name

Shows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. This statement also works with views.

  1. mysql> SHOW CREATE TABLE t\G
  2. *************************** 1. row ***************************
  3.        Table: t
  4. Create Table: CREATE TABLE `t` (
  5.   `id` int(11) NOT NULL AUTO_INCREMENT,
  6.   `s` char(60) DEFAULT NULL,
  7.   PRIMARY KEY (`id`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

SHOW CREATE TABLE quotes table and column names according to the value of the sql_quote_show_create option. See Section 5.1.8, “Server System Variables”.

For information about how CREATE TABLE statements are stored by MySQL, see Section 13.1.20.1, “CREATE TABLE Statement Retention”.


Find a PHP function
Error Infobrol

Can not display this page of the Infobrol website

Type of error (18-01)

Unknown format specifier "&"

Please try again in a few minutes…

Return to the home page




Steph