220 lines
8.5 KiB
Plaintext
220 lines
8.5 KiB
Plaintext
drop table if exists tt;
|
|
create table tt(c1 varchar(100));
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) charset utf8;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) charset utf8, collate utf8_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) charset utf8mb4;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) charset utf8mb4, collate utf8mb4_0900_ai_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) charset utf8mb4, collate utf8mb4_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
drop table tt;
|
|
create table tt(id int);
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`id` int(11) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
alter table tt add column c1 varchar(100);
|
|
show full columns from tt;
|
|
Field Type Collation Null Key Default Extra Privileges Comment
|
|
id int(11) NULL YES NULL select,insert,update,references
|
|
c1 varchar(100) utf8mb4_general_ci YES NULL select,insert,update,references
|
|
alter table tt convert to charset utf8;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`id` int(11) DEFAULT NULL,
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8
|
|
show full columns from tt;
|
|
Field Type Collation Null Key Default Extra Privileges Comment
|
|
id int(11) NULL YES NULL select,insert,update,references
|
|
c1 varchar(100) utf8_general_ci YES NULL select,insert,update,references
|
|
alter table tt convert to charset utf8, collate utf8_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`id` int(11) DEFAULT NULL,
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8
|
|
show full columns from tt;
|
|
Field Type Collation Null Key Default Extra Privileges Comment
|
|
id int(11) NULL YES NULL select,insert,update,references
|
|
c1 varchar(100) utf8_general_ci YES NULL select,insert,update,references
|
|
alter table tt convert to charset utf8mb4;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`id` int(11) DEFAULT NULL,
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
show full columns from tt;
|
|
Field Type Collation Null Key Default Extra Privileges Comment
|
|
id int(11) NULL YES NULL select,insert,update,references
|
|
c1 varchar(100) utf8mb4_general_ci YES NULL select,insert,update,references
|
|
alter table tt convert to charset utf8mb4, collate utf8mb4_0900_ai_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`id` int(11) DEFAULT NULL,
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
show full columns from tt;
|
|
Field Type Collation Null Key Default Extra Privileges Comment
|
|
id int(11) NULL YES NULL select,insert,update,references
|
|
c1 varchar(100) utf8mb4_0900_ai_ci YES NULL select,insert,update,references
|
|
alter table tt convert to charset utf8mb4, collate utf8mb4_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`id` int(11) DEFAULT NULL,
|
|
`c1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
show full columns from tt;
|
|
Field Type Collation Null Key Default Extra Privileges Comment
|
|
id int(11) NULL YES NULL select,insert,update,references
|
|
c1 varchar(100) utf8mb4_0900_ai_ci YES NULL select,insert,update,references
|
|
drop table if exists tt;
|
|
create table tt(c1 varchar(100)) engine=xengine;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=xengine charset utf8;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=xengine charset utf8, collate utf8_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=xengine charset utf8mb4;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=xengine charset utf8mb4, collate utf8mb4_0900_ai_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=xengine charset utf8mb4, collate utf8mb4_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=innodb;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=innodb charset utf8;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=innodb charset utf8, collate utf8_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=innodb charset utf8mb4;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=innodb charset utf8mb4, collate utf8mb4_0900_ai_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
drop table tt;
|
|
create table tt(c1 varchar(100)) engine=innodb charset utf8mb4, collate utf8mb4_general_ci;
|
|
show create table tt;
|
|
Table Create Table
|
|
tt CREATE TABLE `tt` (
|
|
`c1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
create database db_test;
|
|
show create database db_test;
|
|
Database Create Database
|
|
db_test CREATE DATABASE `db_test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
|
|
drop database db_test;
|
|
create database db_test charset utf8mb4;
|
|
show create database db_test;
|
|
Database Create Database
|
|
db_test CREATE DATABASE `db_test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
|
|
drop database db_test;
|
|
create database db_test charset utf8;
|
|
show create database db_test;
|
|
Database Create Database
|
|
db_test CREATE DATABASE `db_test` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */
|
|
drop database db_test;
|
|
create database db_test charset utf8mb4 collate utf8mb4_0900_ai_ci;
|
|
show create database db_test;
|
|
Database Create Database
|
|
db_test CREATE DATABASE `db_test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
|
|
drop database db_test;
|
|
create database db_test charset utf8mb4 collate utf8mb4_general_ci;
|
|
show create database db_test;
|
|
Database Create Database
|
|
db_test CREATE DATABASE `db_test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
|
|
drop database db_test;
|
|
drop table tt;
|