Insert,Select,Update,Delete
Insert into NT values(,,,,,,)
Select * from NT
Update NT set =
Delete from NT
って器をつくらきゃ。
create database '/opt/db/NikkiProject.gdb' user '******' password '******' default character set unicode_fss ;
Create table NT
(
PK integer not null,
CreateDate date,
Author varchar(255),
Title varchar(255),
Subtitle varchar(255),
Category integer,
SubCategory integer,
ParentPK integer,
Status integer,
primary key (PK)
)
こんな感じ？