MySQL syntax Error on create table query?

Question

it leads to error in mysql

create table book_copies
(
   bookid references book(bookid) on delete set null,  
   programme_id references library_branch(programme_id) on delete set null, 
   no_of_copies int
);

enter image description here a

The SQL in your image is different from the text of your answer. Please try to use text only. — Schwern
– Schwern, Commented Dec 5, 2022 at 3:41

Schwern · Accepted Answer · 2022-12-05 03:41:14Z

1

You are lacking types for your columns. Each column needs a type such as int or varchar(255).

If your columns are referencing primary keys, their type is probably int or bigint.

create table book_copies (
  bookid int references book(bookid) on delete set null,
  programme_id int references library_branch(programme_id) on delete set null,
  no_of_copies int
)

answered Dec 5, 2022 at 3:41

Schwern

167k28 gold badges225 silver badges370 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Karthik Hegadi Over a year ago

yes, I got it. how to reference another table thanks!

Collectives™ on Stack Overflow

MySQL syntax Error on create table query?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related