Posted by matt on 07/23/05 02:27

"Steve" <Steve@127.0.0.1> wrote in message
news:jmp7r2-ebu.ln1@barnyard.sweetpig.dyndns.org...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thu, 21 Jul 2005 23:03:51 -0400, matt in alt.comp.databases.mysql
> wrote:
>>does anyone know of any good examples of using INNODB tables and foreign
>>keys to manage references to other tables. I want to manage removing
>>entries and teh references in other tables.
>
>>thanks!
>
> create table xxxx
> (
> xxxID int not null auto_increment primary key,
> name varchar(80),
> job varchar(30),
> xxx00ID int not null references DDD(dddID)
> )
> type=InnoDB;

anybody got anything w/ an explanation?

• Next in forum: How do I SELECT system_time_zone?
• Prev in forum: examples of INNODB & foreign keys
• Thread view: Re: examples of INNODB & foreign keys

[Reply to this message]