On Thu, Nov 19, 2009 at 9:34 PM, Ye Yuan <yuan4...@gmail.com> wrote: > Hi Victor, > > It looks to me the foreign key syntax is wrong. Can you create the > Relationship table on your database by using below ddl? > > create table if not exists Relationship > (ID integer auto_increment primary key, > Parent integer not null, > foreign key (Parent) references categories (ID), > Child integer not null, > foreign key (Child) references categories (ID), > check (Parent <> Child) ); >
Yes, I can create it. Thank you. V