Question

create table book

BOOKID char(4)
bname varchar(15)
author varchar (20)
Price. decimal

identify the primary key of the book table also mention the suitable reason for choosing it as primary key​

Answer 1

The answer Chaz Watkins gave will work for you but the reason your code doesn't work is that you need to use backticks instead of single quotes. The backtick is ` whereas the single quote is '.

It depends on your keyboard layout but often the backtick is found on the key to the left of the 1 key on a keyboard.

Answer 2

BOOK ID WILL BE THE PRIMARY KEY ...

BECAUSE evey id is unique