GIve me bookstore database dataset sample

Asked By 0 points N/A Posted on -
qa-featured

Where can I get bookstore database dataset sample for my project? Here is some information about it. Database will take or give over 100 lines per table. The table will have the Book attributes (BookID, ISBN, Title, Author First etc). Thank you for the suggestion!

SHARE
Answered By 35 points N/A #193473

GIve me bookstore database dataset sample

qa-featured

Hi there,

Your bookstore database is as follows-

Your database name will be bookstore here.

Create table bookstore(

BookId int not NULL auto_increment,

ISBN varchar(50),

Title varchar(100),

Author text);

Now create a table in the database to insert values.

INSERT INTO TABLE(ISBN, title, author) VALUES (absdah4545454, my_first_book, austin peter);

Hope this helped.

Regards,

 

Related Questions