query not executing
-
Can't create table '.\userdb\od.frm' (errno: 150). Getting this error while creating following table in mysql... create table od(no. int,foreign key(no.) references emp(empno));
"no." is a strange column name - I never use dots or commas in a column name. Try "no" or "number" instead. By the way, does your MySQL user have the right to create tables?
-
Can't create table '.\userdb\od.frm' (errno: 150). Getting this error while creating following table in mysql... create table od(no. int,foreign key(no.) references emp(empno));
This is a foreign key error caused by the use of "." in your column identifyers. If you use capital letter format, for example: "ItemNumber" or underscores ("item_number") instead and you should be able to execute. Good luck :)