Jeremiah, if you are using a fairly recent version of MySQL, you can print with
SHOW INNODB STATUS\G a detailed explanation of the latest foreign key error. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Aleksandar Bradaric" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 23, 2004 9:23 PM Subject: Re: CREATE TABLE > Hi, > > > Error: > > ERROR 1005: Can't create table > > './tamiyausa/user_shipping_info.frm' (errno: > > 150) > > C:\mysql\bin>perror 150 > Error code 150: Unknown error > 150 = Foreign key constraint is incorrectly formed > > Look like your foreign keys are not properly defined. Do > both tables exist? And the fields you are referencing? > > > Take care, > Aleksandar > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
