MySQL Forums
Forum List  »  Newbie

Can't create tables?
Posted by: Chris Piekarz
Date: August 21, 2005 02:25PM

Forgive my idiocy; I'm trying to set up a MySQL server for a class I'm taking. I've gotten everything set up so I can access the server from remote computers, which is nice, and now I'm trying to create all the sample tables I'll be using in the class.

We were given SQL statements to run to create everything, and I've gotten most of them done.

I'm unable to create 2 of the tables though. Here's the code for one of them:

CREATE TABLE orders
(order_numb integer NOT NULL,
customer_numb integer NOT NULL ,
order_date date NOT NULL,
credit_card_numb varchar(15) ,
card_card_exp_date char(5) ,
order_filled char(1)
, PRIMARY KEY (order_numb)
, FOREIGN KEY orders2customers (customer_numb
) REFERENCES customers
ON DELETE RESTRICT
);

And here's my error:

Can't create table '.\bookstore\orders.frm' (errno: 150)

Any help would be appreciated. Thanks :)

Options: ReplyQuote


Subject
Written By
Posted
Can't create tables?
August 21, 2005 02:25PM
August 21, 2005 04:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.