mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-02-15 18:05:32 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/jp/r/jp_alter_sjis.result
Monty 6b20342651 Ensure that fields declared with NOT NULL doesn't have DEFAULT values if not specified and if not timestamp or auto_increment 
In original code, sometimes one got an automatic DEFAULT value in some cases, in other cases not.

For example:
create table t1 (a int primary key)      - No default
create table t2 (a int, primary key(a))  - DEFAULT 0
create table t1 SELECT ....              - Default for all fields, even if they where defined as NOT NULL
ALTER TABLE ... MODIFY could sometimes add an unexpected DEFAULT value.

The patch is quite big because we had some many test cases that used
CREATE ... SELECT or CREATE ... (...PRIMARY KEY(xxx)) which doesn't have an automatic DEFAULT anymore.

Other things:
- Removed warnings from InnoDB when waiting from semaphore (got this when testing things with --big)
2015-08-18 11:18:57 +03:00

494 lines
15 KiB
Text
Raw Permalink Blame History

SET NAMES sjis;
SET character_set_database = sjis;
DROP TABLE IF EXISTS `ｱｱｱ`;
DROP TABLE IF EXISTS `ｲｲｲ`;
DROP TABLE IF EXISTS `あああ`;
DROP TABLE IF EXISTS `いいい`;
DROP TABLE IF EXISTS `ソソソ`;
DROP TABLE IF EXISTS `十十十`;
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
CREATE TABLE `ソソソ`(`表表表` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
CREATE TABLE `十十十`(`予予予` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
INSERT INTO `ソソソ` VALUES ('表表表表表'),('構構構構構'),('能能能能能');
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
SELECT * FROM `ｱｱｱ`;
ｶｶ ｷｷｷ ｸｸｸ ｹｹｹ
NULL ｱｱｱｱｱ NULL NULL
NULL ｲｲｲｲｲ NULL NULL
NULL ｳｳｳｳｳ NULL NULL
DESC `ｱｱｱ`;
Field Type Null Key Default Extra
ｶｶ char(1) YES MUL NULL
ｷｷｷ char(6) NO PRI NULL
ｸｸｸ char(1) YES UNI NULL
ｹｹｹ char(1) YES NULL
SHOW CREATE TABLE `ｱｱｱ`;
Table Create Table
ｱｱｱ CREATE TABLE `ｱｱｱ` (
`ｶｶ` char(1) DEFAULT NULL,
`ｷｷｷ` char(6) NOT NULL,
`ｸｸｸ` char(1) DEFAULT NULL,
`ｹｹｹ` char(1) DEFAULT NULL,
PRIMARY KEY (`ｷｷｷ`),
UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
KEY `ｶｶｶ` (`ｶｶ`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
SELECT * FROM `ｱｱｱ`;
ｷｷｷ
ｱｱｱｱｱ
ｲｲｲｲｲ
ｳｳｳｳｳ
DESC `ｱｱｱ`;
Field Type Null Key Default Extra
ｷｷｷ char(6) NO NULL
SHOW CREATE TABLE `ｱｱｱ`;
Table Create Table
ｱｱｱ CREATE TABLE `ｱｱｱ` (
`ｷｷｷ` char(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=sjis
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
ALTER TABLE `あああ` ADD `けけけ` char(1);
ALTER TABLE `あああ` ADD INDEX (`かかか`);
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
ALTER TABLE `あああ` MODIFY `ききき` char(6);
SELECT * FROM `あああ`;
かか ききき くくく けけけ
NULL あああああ NULL NULL
NULL いいいいい NULL NULL
NULL ううううう NULL NULL
DESC `あああ`;
Field Type Null Key Default Extra
かか char(1) YES MUL NULL
ききき char(6) NO PRI NULL
くくく char(1) YES UNI NULL
けけけ char(1) YES NULL
SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`かか` char(1) DEFAULT NULL,
`ききき` char(6) NOT NULL,
`くくく` char(1) DEFAULT NULL,
`けけけ` char(1) DEFAULT NULL,
PRIMARY KEY (`ききき`),
UNIQUE KEY `くくく` (`くくく`),
KEY `かかか` (`かか`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
ALTER TABLE `あああ` DROP INDEX `かかか`;
ALTER TABLE `あああ` DROP PRIMARY KEY;
ALTER TABLE `あああ` DROP INDEX `くくく`;
ALTER TABLE `あああ` DROP `かか`;
ALTER TABLE `あああ` DROP `くくく`;
ALTER TABLE `あああ` DROP `けけけ`;
SELECT * FROM `あああ`;
ききき
あああああ
いいいいい
ううううう
DESC `あああ`;
Field Type Null Key Default Extra
ききき char(6) NO NULL
SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`ききき` char(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=sjis
ALTER TABLE `ソソソ` ADD `構構構` char(1) FIRST;
ALTER TABLE `ソソソ` ADD `能能能` char(1) AFTER `表表表`;
ALTER TABLE `ソソソ` ADD `予予予` char(1);
ALTER TABLE `ソソソ` ADD INDEX (`構構構`);
ALTER TABLE `ソソソ` ADD PRIMARY KEY (`表表表`);
ALTER TABLE `ソソソ` ADD UNIQUE (`能能能`);
ALTER TABLE `ソソソ` CHANGE `構構構` `構構` char(1);
ALTER TABLE `ソソソ` MODIFY `表表表` char(6);
SELECT * FROM `ソソソ`;
構構 表表表 能能能 予予予
NULL 構構構構構 NULL NULL
NULL 能能能能能 NULL NULL
NULL 表表表表表 NULL NULL
DESC `ソソソ`;
Field Type Null Key Default Extra
構構 char(1) YES MUL NULL
表表表 char(6) NO PRI NULL
能能能 char(1) YES UNI NULL
予予予 char(1) YES NULL
SHOW CREATE TABLE `ソソソ`;
Table Create Table
ソソソ CREATE TABLE `ソソソ` (
`構構` char(1) DEFAULT NULL,
`表表表` char(6) NOT NULL,
`能能能` char(1) DEFAULT NULL,
`予予予` char(1) DEFAULT NULL,
PRIMARY KEY (`表表表`),
UNIQUE KEY `能能能` (`能能能`),
KEY `構構構` (`構構`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
ALTER TABLE `ソソソ` DROP INDEX `構構構`;
ALTER TABLE `ソソソ` DROP PRIMARY KEY;
ALTER TABLE `ソソソ` DROP INDEX `能能能`;
ALTER TABLE `ソソソ` DROP `構構`;
ALTER TABLE `ソソソ` DROP `能能能`;
ALTER TABLE `ソソソ` DROP `予予予`;
SELECT * FROM `ソソソ`;
表表表
構構構構構
能能能能能
表表表表表
DESC `ソソソ`;
Field Type Null Key Default Extra
表表表 char(6) NO NULL
SHOW CREATE TABLE `ソソソ`;
Table Create Table
ソソソ CREATE TABLE `ソソソ` (
`表表表` char(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=sjis
DROP TABLE `ｱｱｱ`;
DROP TABLE `ｲｲｲ`;
DROP TABLE `あああ`;
DROP TABLE `いいい`;
DROP TABLE `ソソソ`;
DROP TABLE `十十十`;
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
CREATE TABLE `ソソソ`(`表表表` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
CREATE TABLE `十十十`(`予予予` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
INSERT INTO `ソソソ` VALUES ('表表表表表'),('構構構構構'),('能能能能能');
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
SELECT * FROM `ｱｱｱ`;
ｶｶ ｷｷｷ ｸｸｸ ｹｹｹ
NULL ｱｱｱｱｱ NULL NULL
NULL ｲｲｲｲｲ NULL NULL
NULL ｳｳｳｳｳ NULL NULL
DESC `ｱｱｱ`;
Field Type Null Key Default Extra
ｶｶ char(1) YES MUL NULL
ｷｷｷ char(6) NO PRI NULL
ｸｸｸ char(1) YES UNI NULL
ｹｹｹ char(1) YES NULL
SHOW CREATE TABLE `ｱｱｱ`;
Table Create Table
ｱｱｱ CREATE TABLE `ｱｱｱ` (
`ｶｶ` char(1) DEFAULT NULL,
`ｷｷｷ` char(6) NOT NULL,
`ｸｸｸ` char(1) DEFAULT NULL,
`ｹｹｹ` char(1) DEFAULT NULL,
PRIMARY KEY (`ｷｷｷ`),
UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
KEY `ｶｶｶ` (`ｶｶ`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
SELECT * FROM `ｱｱｱ`;
ｷｷｷ
ｱｱｱｱｱ
ｲｲｲｲｲ
ｳｳｳｳｳ
DESC `ｱｱｱ`;
Field Type Null Key Default Extra
ｷｷｷ char(6) NO NULL
SHOW CREATE TABLE `ｱｱｱ`;
Table Create Table
ｱｱｱ CREATE TABLE `ｱｱｱ` (
`ｷｷｷ` char(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=sjis
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
ALTER TABLE `あああ` ADD `けけけ` char(1);
ALTER TABLE `あああ` ADD INDEX (`かかか`);
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
ALTER TABLE `あああ` MODIFY `ききき` char(6);
SELECT * FROM `あああ`;
かか ききき くくく けけけ
NULL あああああ NULL NULL
NULL いいいいい NULL NULL
NULL ううううう NULL NULL
DESC `あああ`;
Field Type Null Key Default Extra
かか char(1) YES MUL NULL
ききき char(6) NO PRI NULL
くくく char(1) YES UNI NULL
けけけ char(1) YES NULL
SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`かか` char(1) DEFAULT NULL,
`ききき` char(6) NOT NULL,
`くくく` char(1) DEFAULT NULL,
`けけけ` char(1) DEFAULT NULL,
PRIMARY KEY (`ききき`),
UNIQUE KEY `くくく` (`くくく`),
KEY `かかか` (`かか`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
ALTER TABLE `あああ` DROP INDEX `かかか`;
ALTER TABLE `あああ` DROP PRIMARY KEY;
ALTER TABLE `あああ` DROP INDEX `くくく`;
ALTER TABLE `あああ` DROP `かか`;
ALTER TABLE `あああ` DROP `くくく`;
ALTER TABLE `あああ` DROP `けけけ`;
SELECT * FROM `あああ`;
ききき
あああああ
いいいいい
ううううう
DESC `あああ`;
Field Type Null Key Default Extra
ききき char(6) NO NULL
SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`ききき` char(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=sjis
ALTER TABLE `ソソソ` ADD `構構構` char(1) FIRST;
ALTER TABLE `ソソソ` ADD `能能能` char(1) AFTER `表表表`;
ALTER TABLE `ソソソ` ADD `予予予` char(1);
ALTER TABLE `ソソソ` ADD INDEX (`構構構`);
ALTER TABLE `ソソソ` ADD PRIMARY KEY (`表表表`);
ALTER TABLE `ソソソ` ADD UNIQUE (`能能能`);
ALTER TABLE `ソソソ` CHANGE `構構構` `構構` char(1);
ALTER TABLE `ソソソ` MODIFY `表表表` char(6);
SELECT * FROM `ソソソ`;
構構 表表表 能能能 予予予
NULL 表表表表表 NULL NULL
NULL 構構構構構 NULL NULL
NULL 能能能能能 NULL NULL
DESC `ソソソ`;
Field Type Null Key Default Extra
構構 char(1) YES MUL NULL
表表表 char(6) NO PRI NULL
能能能 char(1) YES UNI NULL
予予予 char(1) YES NULL
SHOW CREATE TABLE `ソソソ`;
Table Create Table
ソソソ CREATE TABLE `ソソソ` (
`構構` char(1) DEFAULT NULL,
`表表表` char(6) NOT NULL,
`能能能` char(1) DEFAULT NULL,
`予予予` char(1) DEFAULT NULL,
PRIMARY KEY (`表表表`),
UNIQUE KEY `能能能` (`能能能`),
KEY `構構構` (`構構`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
ALTER TABLE `ソソソ` DROP INDEX `構構構`;
ALTER TABLE `ソソソ` DROP PRIMARY KEY;
ALTER TABLE `ソソソ` DROP INDEX `能能能`;
ALTER TABLE `ソソソ` DROP `構構`;
ALTER TABLE `ソソソ` DROP `能能能`;
ALTER TABLE `ソソソ` DROP `予予予`;
SELECT * FROM `ソソソ`;
表表表
表表表表表
構構構構構
能能能能能
DESC `ソソソ`;
Field Type Null Key Default Extra
表表表 char(6) NO NULL
SHOW CREATE TABLE `ソソソ`;
Table Create Table
ソソソ CREATE TABLE `ソソソ` (
`表表表` char(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=sjis
DROP TABLE `ｱｱｱ`;
DROP TABLE `ｲｲｲ`;
DROP TABLE `あああ`;
DROP TABLE `いいい`;
DROP TABLE `ソソソ`;
DROP TABLE `十十十`;
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
CREATE TABLE `ソソソ`(`表表表` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
CREATE TABLE `十十十`(`予予予` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
INSERT INTO `ソソソ` VALUES ('表表表表表'),('構構構構構'),('能能能能能');
ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
SELECT * FROM `ｱｱｱ`;
ｶｶ ｷｷｷ ｸｸｸ ｹｹｹ
NULL ｱｱｱｱｱ NULL NULL
NULL ｲｲｲｲｲ NULL NULL
NULL ｳｳｳｳｳ NULL NULL
DESC `ｱｱｱ`;
Field Type Null Key Default Extra
ｶｶ char(1) YES MUL NULL
ｷｷｷ char(6) NO PRI NULL
ｸｸｸ char(1) YES UNI NULL
ｹｹｹ char(1) YES NULL
SHOW CREATE TABLE `ｱｱｱ`;
Table Create Table
ｱｱｱ CREATE TABLE `ｱｱｱ` (
`ｶｶ` char(1) DEFAULT NULL,
`ｷｷｷ` char(6) NOT NULL,
`ｸｸｸ` char(1) DEFAULT NULL,
`ｹｹｹ` char(1) DEFAULT NULL,
PRIMARY KEY (`ｷｷｷ`),
UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
KEY `ｶｶｶ` (`ｶｶ`)
) ENGINE=MEMORY DEFAULT CHARSET=sjis
ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
SELECT * FROM `ｱｱｱ`;
ｷｷｷ
ｱｱｱｱｱ
ｲｲｲｲｲ
ｳｳｳｳｳ
DESC `ｱｱｱ`;
Field Type Null Key Default Extra
ｷｷｷ char(6) NO NULL
SHOW CREATE TABLE `ｱｱｱ`;
Table Create Table
ｱｱｱ CREATE TABLE `ｱｱｱ` (
`ｷｷｷ` char(6) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=sjis
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
ALTER TABLE `あああ` ADD `けけけ` char(1);
ALTER TABLE `あああ` ADD INDEX (`かかか`);
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
ALTER TABLE `あああ` MODIFY `ききき` char(6);
SELECT * FROM `あああ`;
かか ききき くくく けけけ
NULL あああああ NULL NULL
NULL いいいいい NULL NULL
NULL ううううう NULL NULL
DESC `あああ`;
Field Type Null Key Default Extra
かか char(1) YES MUL NULL
ききき char(6) NO PRI NULL
くくく char(1) YES UNI NULL
けけけ char(1) YES NULL
SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`かか` char(1) DEFAULT NULL,
`ききき` char(6) NOT NULL,
`くくく` char(1) DEFAULT NULL,
`けけけ` char(1) DEFAULT NULL,
PRIMARY KEY (`ききき`),
UNIQUE KEY `くくく` (`くくく`),
KEY `かかか` (`かか`)
) ENGINE=MEMORY DEFAULT CHARSET=sjis
ALTER TABLE `あああ` DROP INDEX `かかか`;
ALTER TABLE `あああ` DROP PRIMARY KEY;
ALTER TABLE `あああ` DROP INDEX `くくく`;
ALTER TABLE `あああ` DROP `かか`;
ALTER TABLE `あああ` DROP `くくく`;
ALTER TABLE `あああ` DROP `けけけ`;
SELECT * FROM `あああ`;
ききき
あああああ
いいいいい
ううううう
DESC `あああ`;
Field Type Null Key Default Extra
ききき char(6) NO NULL
SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`ききき` char(6) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=sjis
ALTER TABLE `ソソソ` ADD `構構構` char(1) FIRST;
ALTER TABLE `ソソソ` ADD `能能能` char(1) AFTER `表表表`;
ALTER TABLE `ソソソ` ADD `予予予` char(1);
ALTER TABLE `ソソソ` ADD INDEX (`構構構`);
ALTER TABLE `ソソソ` ADD PRIMARY KEY (`表表表`);
ALTER TABLE `ソソソ` ADD UNIQUE (`能能能`);
ALTER TABLE `ソソソ` CHANGE `構構構` `構構` char(1);
ALTER TABLE `ソソソ` MODIFY `表表表` char(6);
SELECT * FROM `ソソソ`;
構構 表表表 能能能 予予予
NULL 表表表表表 NULL NULL
NULL 構構構構構 NULL NULL
NULL 能能能能能 NULL NULL
DESC `ソソソ`;
Field Type Null Key Default Extra
構構 char(1) YES MUL NULL
表表表 char(6) NO PRI NULL
能能能 char(1) YES UNI NULL
予予予 char(1) YES NULL
SHOW CREATE TABLE `ソソソ`;
Table Create Table
ソソソ CREATE TABLE `ソソソ` (
`構構` char(1) DEFAULT NULL,
`表表表` char(6) NOT NULL,
`能能能` char(1) DEFAULT NULL,
`予予予` char(1) DEFAULT NULL,
PRIMARY KEY (`表表表`),
UNIQUE KEY `能能能` (`能能能`),
KEY `構構構` (`構構`)
) ENGINE=MEMORY DEFAULT CHARSET=sjis
ALTER TABLE `ソソソ` DROP INDEX `構構構`;
ALTER TABLE `ソソソ` DROP PRIMARY KEY;
ALTER TABLE `ソソソ` DROP INDEX `能能能`;
ALTER TABLE `ソソソ` DROP `構構`;
ALTER TABLE `ソソソ` DROP `能能能`;
ALTER TABLE `ソソソ` DROP `予予予`;
SELECT * FROM `ソソソ`;
表表表
表表表表表
構構構構構
能能能能能
DESC `ソソソ`;
Field Type Null Key Default Extra
表表表 char(6) NO NULL
SHOW CREATE TABLE `ソソソ`;
Table Create Table
ソソソ CREATE TABLE `ソソソ` (
`表表表` char(6) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=sjis
DROP TABLE `ｱｱｱ`;
DROP TABLE `ｲｲｲ`;
DROP TABLE `あああ`;
DROP TABLE `いいい`;
DROP TABLE `ソソソ`;
DROP TABLE `十十十`;
Reference in a new issue View git blame Copy permalink