Question

write the SQL command or query to create a table called BOOK in OpenOffice base of the following fields
BOOK_ID Char(4)
B_NAME Varchar(15)
AUTHOR Varchar(40)
PRICE Decimal
​

Answer 1

Create database school;

Use school;

Create table BOOK (

BOOK_ID CHAR(4),

B_NAME VARCHAR(15),

AUTHOR VARCHAR(40),

Price_Decimal int(4),);

Thank you

Answer 2

CREATE TABLE "BOOK"

( "BOOK_ID" Char(4),

 "B_NAME" Varchar(15),

 "AUTHOR" Varchar(40),

 "PRICE" Decimal );