Edit File - File Manager

Edit File: tc_multicolumn_same_string.result

DROP TABLE IF EXISTS m2;
CREATE TABLE m2(c1 CHAR(1) NULL, c2 CHAR(5) NOT NULL, c3 CHAR(255) NULL, c4 CHAR(4) NOT NULL PRIMARY KEY, c5 CHAR(30) NOT NULL UNIQUE KEY);
SHOW TABLES;
Tables_in_test
m2
SHOW CREATE TABLE m2;
Table	Create Table
m2	CREATE TABLE `m2` (
  `c1` char(1) DEFAULT NULL,
  `c2` char(5) NOT NULL,
  `c3` char(255) DEFAULT NULL,
  `c4` char(4) NOT NULL,
  `c5` char(30) NOT NULL,
  PRIMARY KEY (`c4`),
  UNIQUE KEY `c5` (`c5`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE m2;
SHOW TABLES;
Tables_in_test
CREATE TABLE m2(c1 VARCHAR(1) NULL, c2 VARCHAR(5) NOT NULL, c3 VARCHAR(255) NULL, c4 VARCHAR(4) NOT NULL PRIMARY KEY, c5 VARCHAR(30) NOT NULL UNIQUE KEY);
SHOW TABLES;
Tables_in_test
m2
SHOW CREATE TABLE m2;
Table	Create Table
m2	CREATE TABLE `m2` (
  `c1` varchar(1) DEFAULT NULL,
  `c2` varchar(5) NOT NULL,
  `c3` varchar(255) DEFAULT NULL,
  `c4` varchar(4) NOT NULL,
  `c5` varchar(30) NOT NULL,
  PRIMARY KEY (`c4`),
  UNIQUE KEY `c5` (`c5`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE m2;
SHOW TABLES;
Tables_in_test
CREATE TABLE m2(c1 BINARY(1) NULL, c2 BINARY(5) NOT NULL, c3 BINARY(255) NULL, c4 BINARY(4) NOT NULL PRIMARY KEY, c5 BINARY(30) NOT NULL UNIQUE KEY);
SHOW TABLES;
Tables_in_test
m2
SHOW CREATE TABLE m2;
Table	Create Table
m2	CREATE TABLE `m2` (
  `c1` binary(1) DEFAULT NULL,
  `c2` binary(5) NOT NULL,
  `c3` binary(255) DEFAULT NULL,
  `c4` binary(4) NOT NULL,
  `c5` binary(30) NOT NULL,
  PRIMARY KEY (`c4`),
  UNIQUE KEY `c5` (`c5`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE m2;
SHOW TABLES;
Tables_in_test
CREATE TABLE m2(c1 VARBINARY(1) NULL, c2 VARBINARY(5) NOT NULL, c3 VARBINARY(255) NULL, c4 VARBINARY(4) NOT NULL PRIMARY KEY, c5 VARBINARY(30) NOT NULL UNIQUE KEY);
SHOW TABLES;
Tables_in_test
m2
SHOW CREATE TABLE m2;
Table	Create Table
m2	CREATE TABLE `m2` (
  `c1` varbinary(1) DEFAULT NULL,
  `c2` varbinary(5) NOT NULL,
  `c3` varbinary(255) DEFAULT NULL,
  `c4` varbinary(4) NOT NULL,
  `c5` varbinary(30) NOT NULL,
  PRIMARY KEY (`c4`),
  UNIQUE KEY `c5` (`c5`)
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE m2;
SHOW TABLES;
Tables_in_test

Back to File Manager