Question

write SQR query to create a table"book" Bookid. char(25). Bookname. varchar(25). Bauthor varchar(25). Bprice varchaer(25). ​

Answer 1

CREATE TABLE BOOK

(

BOOK_ID VARCHAR (25) ,

BOOK_NAME VARCHAR (25) ,

BOOK_AUTHOR VARCHAR (25) ,

BOOK_PRICE VARCHAR (25)

);

Book price should be in decimal......plz check the question again......if it's varchar thn no prblm....btt if it's decimal thn write DECIMAL over the place of VARCHAR and also write the length..,..