 | | | ERROR 1005 | ERROR 1005 2005-04-26 - By Jason Lim
Back
Greetings,
'-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-
mysql> CREATE DATABASE demo40;
mysql> USE demo40
mysql> CREATE TABLE employee (pkey INT NOT NULL AUTO_INCREMENT, PRIMARY KEY
(pkey));
ERROR 1005: Can't create table '.\demo40\employee.frm' (errno: 150)
'-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
-- ---- ---- ---- ---- ---- ---- ---- ---- ------
I get the above error message when I tried to create the 'employee' table. I
understand this error is due to bad constraints and foreign key references, but
this is the first table I'm creating and there's no constraint field involved.
However. when I create a database and name it other than 'demo40', the table
creation works perfectly.
Please advise. Thank you.
Jason
Earn $52 per hosting referral at Lunarpages.
|
|
|