数据库同步表创建

Zss 发表于:
Msysql8:

CREATE TABLE `mysqltest` (
`id` bigint(20) NOT NULL,
`floatnumber` float(20) NULL,
`name` varchar(100) NULL,
`namevchar` varchar(100) NULL,
`time` datetime NULL,
`payloads` longblob NULL,
PRIMARY KEY (`id`)
)

Sqlserver2019:

CREATE TABLE sqlservertest (
id numeric(20) not NULL,
floatnumber float(20) NULL,
name char(100) NULL,
namevchar varchar(100) NULL,
time date NULL,
payloads varbinary(max) NULL,
PRIMARY KEY (id)
)

insert into sqlservertest values (6,2.2222,'hehe呵呵','hahsh哈哈','2007-12-28 10:07:24',0x4543223456789)
delete sqlservertest where id ='1'
select * from sqlservertest

旧版本sqlserver:

CREATE TABLE sqlservertest (
id numeric(20) not NULL,
floatnumber float(20) NULL,
name char(100) NULL,
namevchar varchar(100) NULL,
time date NULL,
payloads image NULL,
PRIMARY KEY (id)
)

Oracle18c:

CREATE TABLE oracletest (
id numeric(20) not NULL,
floatnumber NUMBER NULL,
name char(100) NULL,
namevchar varchar2(100) NULL,
time date NULL,
payloads blob NULL,
PRIMARY KEY (id)
)

sybase:

CREATE TABLE sybasetest1 (
id numeric(20) not NULL,
floatnumber numeric(10,5)NULL,
name char(100) NULL,
namevchar varchar(100) NULL,
time datetime NULL,
payloads text NULL,
PRIMARY KEY (id)
)