Re: Need help with a 1005 error (errno: 150), please...

2003-07-07 Thread gerald_clark
You must create the key (sku), it is not created for you. Tom Gazzini wrote: I would appreciate some help with a problem. I'm trying to create two tables that have referential integrity. If I try and create the following table it works fine: CREATE TABLE book ( sku INT ) TYPE=INNODB; However,

RE: Need help with a 1005 error (errno: 150), please...

2003-07-07 Thread Tom Gazzini
Please ignore my last email. I made a nauseatingly dumb error in the book table (sku should be CHAR(14), not INT). The only help I need is to get some sleep. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL