Entries : Category [ NP ]
まだ内緒にしたい
[Zakkan]  [mobile]  [NP]  [Zope]  [Linux]  [COREBlog]  [HeatWave]  [PA]  [Windows]  [うちの子語録]  [python]  [Weight] 

11 December
2003

Insert,Select,Update,Delete

[NP] 

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)
)

こんな感じ?


Posted by shinobu at 14:20 | Comments (2) | Trackbacks (0)

接続前

[NP] 

set names unicode_fss;

connect '/opt/db/NikkiProject.gdb' user '******' password '******';

むかしはシングルコーテーションで囲まないでよかったような気が。


Posted by shinobu at 15:16 | Comments (2) | Trackbacks (0)
[1]