CREATE TABLE all_ts (
tinyint_TEST TINYINT,
bool_TEST BOOL,
boolean_TEST BOOLEAN,
smallint_TEST SMALLINT,
mediumint_TEST MEDIUMINT,
int_TEST INT primary key,
integer_TEST INTEGER,
bigint_TEST BIGINT,
real_TEST REAL,
float_TEST FLOAT,
double_TEST DOUBLE,
decimal_TEST DECIMAL(30,2),
numeric_TEST NUMERIC(30,2),
datetime_TEST DATETIME,
timestamp_TEST TIMESTAMP,
time_TEST TIME,
date_TEST DATE,
char_TEST CHAR(10),
varchar_TEST VARCHAR(255),
tinyblob_TEST TINYBLOB,
tinytext_TEST TINYTEXT,
text_TEST TEXT,
mediumblob_TEST MEDIUMBLOB,
mediumtext_TEST MEDIUMTEXT,
longblob_TEST LONGBLOB,
longtext_TEST LONGTEXT
);
INSERT INTO all_ts VALUES (
127, -- TINYINT
TRUE, -- BOOLEAN
TRUE, -- BOOLEAN (或可以使用0和1代替TRUE和FALSE)
32767, -- SMALLINT
8388607, -- MEDIUMINT用INT代替
23, -- INT
2147483647, -- INTEGER (与INT等价)
922337203685477580, -- BIGINT
123.45, -- REAL
123.456, -- FLOAT
123456.789, -- DOUBLE
1234567890.12, -- DECIMAL(30,2)
1234567890.12, -- NUMERIC(30,2) (与DECIMAL等价)
'2023-10-23 14:30:56', -- DATETIME
'2023-10-23 14:30:56', -- TIMESTAMP
'14:56:56', -- TIME
'2023-10-23', -- DATE
'SampleChar', -- CHAR(10)
'SampleVarchar', -- VARCHAR(255)
'TinyBlobData', -- TINYBLOB (可以直接转换)
'TinyTextData', -- TINYTEXT (可以直接插入字符串)
'TextDataSample', -- TEXT
'MediumBlobData', -- MEDIUMBLOB (可以直接转换)
'MediumTextData', -- MEDIUMTEXT (可以直接插入字符串)
'LongBlobData', -- LONGBLOB (可以直接转换)
'LongTextDataSample' -- LONGTEXT (可以直接插入字符串)
),(
-127, -- TINYINT
TRUE, -- BOOLEAN
0, -- BOOLEAN (或可以使用0和1代替TRUE和FALSE)
-32767, -- SMALLINT
-8388607, -- MEDIUMINT用INT代替
24, -- INT
-2147483647, -- INTEGER (与INT等价)
-922337203685477580, -- BIGINT
-123.45, -- REAL
-123.456, -- FLOAT
-123456.789, -- DOUBLE
-1234567890.12, -- DECIMAL(30,2)
-1234567890.12, -- NUMERIC(30,2) (与DECIMAL等价)
'2023-10-23 14:32:01', -- DATETIME
'2023-10-23 14:39:01', -- TIMESTAMP
'14:34:12', -- TIME
'2023-10-23', -- DATE
'SampleChar', -- CHAR(10)
'SampleVarchar', -- VARCHAR(255)
'TinyBlobData', -- TINYBLOB (可以直接转换)
'TinyTextData', -- TINYTEXT (可以直接插入字符串)
'TextDataSample', -- TEXT
'MediumBlobData', -- MEDIUMBLOB (可以直接转换)
'MediumTextData', -- MEDIUMTEXT (可以直接插入字符串)
'LongBlobData', -- LONGBLOB (可以直接转换)
'LongTextDataSample' -- LONGTEXT (可以直接插入字符串)
);
CREATE TABLE all_tcs (
tinyint_TEST TINYINT,
bool_TEST BOOL,
boolean_TEST BOOLEAN,
smallint_TEST SMALLINT,
mediumint_TEST MEDIUMINT,
int_TEST INT primary key,
integer_TEST INTEGER,
bigint_TEST BIGINT,
real_TEST REAL,
float_TEST FLOAT,
double_TEST DOUBLE,
decimal_TEST DECIMAL(30,2),
numeric_TEST NUMERIC(30,2),
datetime_TEST DATETIME,
timestamp_TEST TIMESTAMP,
time_TEST TIME,
date_TEST DATE,
char_TEST CHAR(10),
varchar_TEST VARCHAR(255),
tinyblob_TEST TINYBLOB,
tinytext_TEST TINYTEXT,
text_TEST TEXT,
mediumblob_TEST MEDIUMBLOB,
mediumtext_TEST MEDIUMTEXT,
longblob_TEST LONGBLOB,
longtext_TEST LONGTEXT
);
gbase sql 建表及插入数据
最新推荐文章于 2024-09-13 21:58:02 发布