1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
CREATE SCHEMA data_dictionary;
CREATE SCHEMA test_columns;
use test_columns;
CREATE TABLE types (
a integer,
b bigint,
c varchar(10),
d double,
e blob,
f enum("yes", "no"),
g decimal,
h date,
j timestamp,
k datetime
);
SELECT DATA_TYPE FROM data_dictionary.columns WHERE TABLE_SCHEMA="test_columns" GROUP BY DATA_TYPE;
DATA_TYPE
BIGINT
BLOB
DATE
DATETIME
DECIMAL
DOUBLE
ENUM
INTEGER
TIMESTAMP
VARCHAR
DROP SCHEMA test_columns;
DROP SCHEMA data_dictionary;
|