I can't seem to be able to create foreign keys. Here are my create
procedures and the error I am receiving.
CREATE TABLE `test1` (
`a_id` smallint(6) NOT NULL default '0',
PRIMARY KEY (`a_id`),
KEY `a_id` (`a_id`)
) TYPE=InnoDB;
CREATE TABLE `test2` (
`b_id` smallint(6) NOT NULL default '0',
`c_id` smallint(6) NOT NULL default '0',
PRIMARY KEY (`b_id`),
KEY `b_id` (`b_id`)
) TYPE=InnoDB;
mysql> alter table test2 add constraint
-> FOREIGN KEY (c_id) REFERENCES test1 (a_id);
ERROR 1005: Can't create table './inventory/#sql-267_4.frm' (errno: 150)
This seems very simple. Is there a problem in my alter statement?
William Hambleton
Humana Inc.
Technical Analyst
Pho. 502.580.1657
Fax. 502.580.1288
- - - - - - - - - - - - - - - - - - - -
The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you
receive this material/information in error, please contact the sender and
delete or destroy the material/information.
- - - - - - - - - - - - - - - - - - - -
