From: Serkan Coban (scobanx@yahoo.com)
Date: Tue 16 Mar 2004 - 03:49:04 EST
merhaba foreign key destegi icin INNODB table
kullanmalisiniz ornekleri sql documentationunda var
asaguda bi ornek yaziyorum:
CREATE TABLE employee (employee_no INTEGER, name
VARCHAR(50),
skill VARCHAR(20), salary FLOAT, date_of_birth DATE,
year_joined DATE,
address VARCHAR(50), postcode CHAR(10), city
VARCHAR(20),
PRIMARY KEY(employee_no)) TYPE=INNODB;
CREATE TABLE project (project_no VARCHAR(10) NOT NULL,
p_name VARCHAR(20),
p_manager INTEGER, start_date DATE, due_date DATE,
budget FLOAT,
PRIMARY KEY(project_no)) TYPE=INNODB;
CREATE TABLE assigned(project_no VARCHAR(10),
employee_no INTEGER,
assignment_date DATE, INDEX (project_no), FOREIGN KEY
(project_no) REFERENCES project(project_no),
INDEX (employee_no), FOREIGN KEY (employee_no)
REFERENCES employee(employee_no)) TYPE=INNODB;
--- Nebi Senol Yilmaz <nsenol_yilmaz@yahoo.com> wrote:
>
>
> merhaba;
>
> mysql-4.0.18 server kurulu durumda
> cerate table statement'inda foreign key vermek icin
> ifadeleri yaziyorum, sql normal sekilde
> calisiyor(hata
> olusmuyor)
>
> fakat tabloya insert yaparken foreign key yokmus
> gibi
> hsreket ediyor, foreign keydeki kisitlamam yokmus
> gibi
> veriler insert oluyor....
>
> 4.0.18 foreign key desteklemiyor mu? mysql.com'da
> create syntax'inda 3.x.x ve uzeri versiyonlar icin
> gecerli syntax'i kullaniyorum...
>
> asagida ornek bir create var...
>
> create table xinfo(xxx char(10), yyy char(10),
> primary
> key(xxx), foreign key(yyy) references
> yyy_desc(type));
>
>
> sorun nerede olabilir...?
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - More reliable, more storage, less spam
> http://mail.yahoo.com
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com