Creating a table in Mysql with phpadmin

Question

I keep getting errors when trying to create a products table for a database I'm building.

Here is the code I've tried:

CREATE TABLE Products (
    ProductId int NOT NULL auto_increment primary key,
    Name varchar(255) NOT NULL,
    Price decimal(19, 4),
    on_hand integer, 
    supp_id int,
    FOREIGN KEY (supp_id) REFERENCES Suppliers(supp_id)
);

I am getting this error code:

#1005 - Can't create table 'computer_wholesale.products' (errno: 150

Any help would be greatly appreciated.

Check this possible duplicate http://stackoverflow.com/questions/4061293/mysql-cant-create-table-errno-150 — Sami, May 30 '15 at 19:04
Check [this](http://stackoverflow.com/a/9018753/4576237). Ensure that your foreign key has the exact same type as the primary key — mysqlrockstar, May 30 '15 at 19:05

NightOwlPrgmr · Answer 1 · 2015-05-30T19:09:49.233

1

I believe your Suppliers table is missing an index, which is required to use a FOREIGN KEY with.

edited May 30 '15 at 19:09

answered May 30 '15 at 19:04

NightOwlPrgmr

1,322
3
21
31

`computer_wholesale` is the database name – mysqlrockstar May 30 '15 at 19:06

Creating a table in Mysql with phpadmin

1 Answers1