#1005 - Cant create table... (errno: 150)

Question

I have all the primary keys and drop tables in the correct order.

I basically want stockID to be a foreign key in my refund table.

My schema looks like this...

CREATE TABLE refunds (
refundID SMALLINT AUTO_INCREMENT,
stockID SMALLINT,
refundDate DATE,
FOREIGN KEY (stockID) REFERENCES tblStock(stockID),
PRIMARY KEY (refundID)
);

CREATE TABLE tblStock (
stockID SMALLINT AUTO_INCREMENT,
stockName VARCHAR(60),
StockNumbers SMALLINT
);

so you are creating `refunds` first and then `tblStock`? If thats true, try the `tblStock` first and then the `refunds`. — KrazzyNefarious, Mar 20 '14 at 18:38

score 1 · Accepted Answer · answered Mar 20 '14 at 18:38

1

When referencing another table for a foreign key reference, that table needs to already exist. And, the column being referenced should be a primary key. Try this:

CREATE TABLE tblStock (
  stockID SMALLINT AUTO_INCREMENT PRIMARY KEY,
  stockName VARCHAR(60),
  StockNumbers SMALLINT
);

CREATE TABLE refunds (
  refundID SMALLINT AUTO_INCREMENT,
  stockID SMALLINT,
  refundDate DATE,
  FOREIGN KEY (stockID) REFERENCES tblStock(stockID),
  PRIMARY KEY (refundID)
);

answered Mar 20 '14 at 18:38

Gordon Linoff

1,242,037
58
646
786

I don't understand the question in your comment. Perhaps you should ask another question (because it doesn't seem related to this one) with a good example of exactly what you are trying to accomplish. – Gordon Linoff Mar 20 '14 at 18:52

score 0 · Answer 2 · answered Mar 20 '14 at 18:39

0

FOREIGN KEY (stockID) REFERENCES tblStock(stockID)

Is referencing a table that doesn't yet exist. Create tblStock first.

answered Mar 20 '14 at 18:39

mseifert

5,390
9
38
100

score 0 · Answer 3 · answered Oct 22 '14 at 20:02

0

You are referencing a table that doesn't exist. Create it first.

In addition, you will want to index the key you are referencing. Make sure any value being referenced in your foreign key actually exists.

answered Oct 22 '14 at 20:02

Codhidharma

36
2

#1005 - Cant create table... (errno: 150)

3 Answers3