Question

Create a table named book by defining the field book ld book name price publisher category and number of pages enter 25 records in it and perform all the operations

Answer 1

Answer: In this problem,

The query can be written in different platforms.

MySQL:

CREATE TABLE book(

book_id  int NOT NULL,

name varchar(255),

price int,

publisher varchar(255),

catagory varchar(255),

Num_of_pages int

);

SQL Server / Oracle / MS Access:

CREATE TABLE book(

book_id  int NOT NULL PRIMARY KEY,

name varchar(255),

price int,

publisher varchar(255),

catagory varchar(255),

Num_of_pages int

);