MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: ERROR 1005 <HY000> : cant create table constructco.emp_1 <errno : 150>
Posted by: Rick James
Date: November 17, 2013 01:40AM

Create the tables in the reverse order.

Check the syntax on FOREIGN KEY.

Yikes -- Only one field can be AUTO_INCREMENT, and that can't be VARCHAR.

Study the manual some more.



Edited 1 time(s). Last edit at 11/17/2013 01:42AM by Rick James.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1005 <HY000> : cant create table constructco.emp_1 <errno : 150>
1717
ashwini kolloju
November 15, 2013 02:15PM
Re: ERROR 1005 <HY000> : cant create table constructco.emp_1 <errno : 150>
867
Rick James
November 17, 2013 01:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.