GIve me bookstore database dataset sample

Asked By austin peter 0 points N/A Posted on - 04/02/2013

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!

• Status: Open
• Question Views: 668
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Internet/Email Software

Answered By Joseph S Peterson 35 points N/A #193473

GIve me bookstore database dataset sample

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,

 

About Joseph S Peterson

Questions
19

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 04/09/2013
• Question Category: Internet/Email Software