–1.数据库测试基本数据类型
–1.1 mysql基本数据类型
tinyint
smallint
mediumint
int
bigint
float
double
decimal
char
varchar
tinyblob
blob
mediumblob
longblob
tinytext
text
mediumtext
longtext
date
time
year
datetime
timestamp
–1.2 oracle基本数据类型
number
integer
float
binary_float
binary_double
char
nchar
varchar2
nvarchar2
date
timestamp
timestamp with time zone
timestamp with local time zone
clob
nclob
blob
bfile
long
raw
rowid
urowid
–1.3 mysql abc用户 建库建表project01
create database project01 DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
use project01;
create table basicdata_test(
num_ti tinyint,
num_si smallint,
num_mi mediumint,
num_i int,
num_bi bigint,
num_f float,
num_d double,
num_deci decimal,
ch_c char,
ch_vc varchar(30),
lob_tb tinyblob,
lob_bb blob,
lob_mb mediumb