各类数据库适配mysql

发布时间 2023-05-31 15:00:08作者: KeepSmiling_me

1.clickhouse:

Array(Date)=TEXT
Array(DateTime=TEXT
Array(FLoat32)=TEXT
Array(FLoat64)=TEXT
Array(Int16)=TEXT
Array(Int32)=TExT
Array(Int64)=TEXT
Array(Int8)TExT
DateTime=DATETIME
Anray(stringD=TExT
Array(UInt16)=INT
Arav(uInt32)=INT
Array(UInt64)=INT
Array(UInt8)=INT
UInt16=SMALLINTC5)
UInt32=INT(10))
UInt64=BIGINT(20)
UInt8-TINYINT(3)
Int8=TINYINT(4)
Int16=SMALLINT(6)
Int32=INT(11)
Int64=BIGINT(20)
FLoat32=FL0AT(24)
FLoat64=D0UBLE(53)
Fixedstring=CHAR(255)
String=VARCHAR(255)

2.Oracle

Array(Date)=TEXT
Array(DateTime=TEXT
Array(FLoat32)=TEXT
Array(FLoat64)=TEXT
Array(Int16)=TEXT
Array(Int32)=TExT
Array(Int64)=TEXT
Array(Int8)TExT
DateTime=DATETIME
Anray(stringD=TExT
Array(UInt16)=INT
Arav(uInt32)=INT
Array(UInt64)=INT
Array(UInt8)=INT
UInt16=SMALLINTC5)
UInt32=INT(10))
UInt64=BIGINT(20)
UInt8-TINYINT(3)
Int8=TINYINT(4)
Int16=SMALLINT(6)
Int32=INT(11)
Int64=BIGINT(20)
FLoat32=FL0AT(24)
FLoat64=D0UBLE(53)
Fixedstring=CHAR(255)

3.postgresql:

integer=INT
int4=INT
SmaLLint=SMALLINT
int2=SMALLINT
bigint=BIGINT
int8=BIGINT
reaL=FLOAT
fLoat4=FLOAT
double-precision=DouBLE
fLoat8=D0UBLE
characten_varying=VARCHAR(255)
varchar=VARCHAR(255)
bpchar=VARCHAR(255)
gzgu
character=CHAR(255char=CHAR(255)
afily
teXt=LONGTEXT
timestamp_without_time_zone=DATETIME
timestampwith time_zone=TIMEsTAMP
timestamp=TIMEsTAMP
date=DATE
time_without_time_zone=TIME
numeric=DECIMAL
booLean=TINYINT(1)
bytea=BLOB