derbyデータ型
1596 ワード
mysql , derby , :
:
mysql :
create table JYS
(
ID int not null,
qsrq datetime,
zzrq datetime,
primary key (ID)
);
derby :
create table JYS
(
ID int not null,
qsrq TIMESTAMP,
zzrq TIMESTAMP,
primary key (ID)
);
datetime ----------> TIMESTAMP
:
mysql :
create table DW
(
id int not null auto_increment,
mc varchar(50),
primary key (id)
);
derby :
create table DW
(
id int generated by default as identity,
mc varchar(50),
primary key (id)
);
int not null auto_increment -----------------> int generated by default as identity
bool :
mysql :
create table YSPF
(
ID int not null,
tgsj bool,
primary key (ID)
);
derby :
create table YSPF
(
ID int not null,
tgsj varchar(1),
primary key (ID)
);
bool -------------------------> varchar(1)
http://db.apache.org/ddlutils/databases/derby.html