Edit File - File Manager

Edit File: tc_structure_string_comment.result

DROP TABLE IF EXISTS t1;
CREATE TABLE t1(c1 CHAR(10) NULL) COMMENT = 'This table has a CHAR column';
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` char(10) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a CHAR column'
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1(c1 VARCHAR(10) NULL) COMMENT = 'This table has a VARCHAR column';
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` varchar(10) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a VARCHAR column'
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1(c1 BINARY(10) NULL) COMMENT = 'This table has a BINARY column';
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` binary(10) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BINARY column'
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1(c1 VARBINARY(10) NULL) COMMENT = 'This table has a VARBINARY column';
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` varbinary(10) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a VARBINARY column'
DROP TABLE t1;
SHOW TABLES;
Tables_in_test

Back to File Manager