1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(100) NULL, c2 CHAR(100) NULL);
3
INSERT INTO t1 VALUES('abc','ABCDEFG');
4
INSERT INTO t1 VALUES('123','1234567890');
6
Table Op Msg_type Msg_text
7
test.t1 analyze status OK
9
CREATE TABLE t1(c1 VARCHAR(100) NULL, c2 VARCHAR(100) NULL);
10
INSERT INTO t1 VALUES('abc','ABCDEFG');
11
INSERT INTO t1 VALUES('123','1234567890');
13
Table Op Msg_type Msg_text
14
test.t1 analyze status OK
16
CREATE TABLE t1(c1 BINARY(100) NULL, c2 BINARY(100) NULL);
17
INSERT INTO t1 VALUES('abc','ABCDEFG');
18
INSERT INTO t1 VALUES('123','1234567890');
20
Table Op Msg_type Msg_text
21
test.t1 analyze status OK
23
CREATE TABLE t1(c1 VARBINARY(100) NULL, c2 VARBINARY(100) NULL);
24
INSERT INTO t1 VALUES('abc','ABCDEFG');
25
INSERT INTO t1 VALUES('123','1234567890');
27
Table Op Msg_type Msg_text
28
test.t1 analyze status OK
30
CREATE TABLE t1(c1 BLOB(100) NULL, c2 BLOB(100) NULL);
31
INSERT INTO t1 VALUES('abc','ABCDEFG');
32
INSERT INTO t1 VALUES('123','1234567890');
34
Table Op Msg_type Msg_text
35
test.t1 analyze status OK
37
CREATE TABLE t1(c1 TEXT(100) NULL, c2 TEXT(100) NULL);
38
INSERT INTO t1 VALUES('abc','ABCDEFG');
39
INSERT INTO t1 VALUES('123','1234567890');
41
Table Op Msg_type Msg_text
42
test.t1 analyze status OK