Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.37-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use bookstoresystem
Database changed
mysql> select *
-> from publisher;
+----------------+--------------------------+--------------+
| Publisher_Code | Publisher_Name | City |
+----------------+--------------------------+--------------+
| AH | Arkham House | Sauk City WI |
| AP | Areade Publishing | New York |
| BA | Basic Books | Boulder CO |
| BP | Berkley publishing | Boston |
| BY | Back Bay Books | New York |
| CT | Couse Technology | Boston |
| FA | Fawcett Books | New York |
| FS | Farrar Straus and Giroux | New York |
| HC | HarperCollins Publisher | New York |
| JP | Jove Publication | New York |
| JT | Jeremy P.Tarcher | Los Angeles |
| LB | Lb Bokks | New York |
| MP | McPherson and Co | Kingston |
| PE | Penguin USA | New York |
| PL | Plume | New York |
| PU | Putnam Publishing Group | New York |
| RH | Random House | New York |
| SB | Schoken Books | New York |
| SG | Scribner | New York |
| SS | Simon and Schuster | New York |
| ST | Scholastic Trade | New York |
| TA | Taunton Press | Newtown CT |
| TB | Tor Books | New York |
| TH | Thames and Hudson | New York |
| TO | Touchstone Books | Westport CT |
| VB | Vintage Books | New York |
| WN | W.W.Norton | New York |
| WP | Westview Press | Boulder CO |
+----------------+--------------------------+--------------+
28 rows in set (0.05 sec)
mysql> select city from publisher;
+--------------+
| city |
+--------------+
| Sauk City WI |
| New York |
| Boulder CO |
| Boston |
| New York |
| Boston |
| New York |
| New York |
| New York |
| New York |
| Los Angeles |
| New York |
| Kingston |
| New York |
| New York |
| New York |
| New York |
| New York |
| New York |
| New York |
| New York |
| Newtown CT |
| New York |
| New York |
| Westport CT |
| New York |
| New York |
| Boulder CO |
+--------------+
28 rows in set (0.00 sec)
mysql> select*
-> from book;
+-----------+------------------------------------------+----------------+------+
-------+-----------+
| Book_Code | Title | Publisher_Code | Type |
price | Peperback |
+-----------+------------------------------------------+----------------+------+
-------+-----------+
| 0180 | A Deepness in the Sky | TB | SFI |
7.00 | Y |
| 0189 | Magic terror | FA | HOR |
8.00 | Y |
| 0200 | The Stranger | VB | FIC |
8.00 | Y |
| 0378 | Venice | SS | ART |
24.50 | N |
| 079X | Second Wind | PU | MYS |
24.95 | N |
| 0808 | The Edge | JP | MYS |
6.99 | N |
| 1351 | Dreamcatcher A Novel | SC | HOR |
19.60 | N |
| 1382 | Treasure Chests | TA | ART |
24.46 | N |
| 138X | Beloved | PL | FIC |
12.95 | Y |
| 2226 | Harry Potter and the Prisoner of Azkaban | ST | SFI |
13.96 | N |
| 2281 | Van Gogh and Gauguin | WP | ART |
21.00 | N |
| 2766 | Of Mice and Men | PE | FIC |
6.95 | Y |
| 2908 | Electric | FS | POE |
14.00 | N |
| 3350 | Group Six People in Search of a life | BP | PSY |
10.40 | Y |
| 3743 | Nine Stories | LB | FIC |
5.99 | Y |
| 3906 | The Soul of a New Machine | BY | SCI |
11.16 | Y |
| 5163 | Travels with Charley | PE | TRA |
7.95 | Y |
| 5790 | Catch 22 | SC | FIC |
12.00 | Y |
| 6128 | jazz | PL | FIC |
12.95 | Y |
| 6328 | Band of Brothers | TO | HIS |
9.60 | Y |
| 669X | AGuide to SQL | CT | CMP |
37.95 | Y |
| 6908 | Franny and Zooey | LB | FIC |
5.99 | Y |
| 7405 | East of Eden | PE | FIC |
12.95 | Y |
| 7443 | Harry Potter and the Goblet of Fire | ST | SFI |
18.16 | N |
| 7559 | The Fall | VB | FIC |
8.00 | Y |
| 8092 | Godel Escher Bach | BA | PHI |
14.00 | Y |
| 8720 | When Rabbit Howls | JA | PSY |
6.29 | Y |
| 9611 | Black House | RH | HOR |
18.81 | N |
| 9627 | Song of Solomon | PL | FIC |
14.00 | Y |
| 9701 | The Grapes of Wrath | PE | FIC |
13.00 | Y |
| 9880 | Slay Ride | JP | MYS |
6.99 | Y |
| 9883 | The Catcher in the Rye | LB | FIC |
5.99 | Y |
| 9931 | To Kill a Mockingbird | HC | FIC |
18.00 | N |
+-----------+------------------------------------------+----------------+------+
-------+-----------+
33 rows in set (0.03 sec)
mysql> select title peperback from book;
+------------------------------------------+
| peperback |
+------------------------------------------+
| A Deepness in the Sky |
| Magic terror |
| The Stranger |
| Venice |
| Second Wind |
| The Edge |
| Dreamcatcher A Novel |
| Treasure Chests |
| Beloved |
| Harry Potter and the Prisoner of Azkaban |
| Van Gogh and Gauguin |
| Of Mice and Men |
| Electric |
| Group Six People in Search of a life |
| Nine Stories |
| The Soul of a New Machine |
| Travels with Charley |
| Catch 22 |
| jazz |
| Band of Brothers |
| AGuide to SQL |
| Franny and Zooey |
| East of Eden |
| Harry Potter and the Goblet of Fire |
| The Fall |
| Godel Escher Bach |
| When Rabbit Howls |
| Black House |
| Song of Solomon |
| The Grapes of Wrath |
| Slay Ride |
| The Catcher in the Rye |
| To Kill a Mockingbird |
+------------------------------------------+
33 rows in set (0.00 sec)
mysql> select publisher_name, city from publisher;
+--------------------------+--------------+
| publisher_name | city |
+--------------------------+--------------+
| Arkham House | Sauk City WI |
| Areade Publishing | New York |
| Basic Books | Boulder CO |
| Berkley publishing | Boston |
| Back Bay Books | New York |
| Couse Technology | Boston |
| Fawcett Books | New York |
| Farrar Straus and Giroux | New York |
| HarperCollins Publisher | New York |
| Jove Publication | New York |
| Jeremy P.Tarcher | Los Angeles |
| Lb Bokks | New York |
| McPherson and Co | Kingston |
| Penguin USA | New York |
| Plume | New York |
| Putnam Publishing Group | New York |
| Random House | New York |
| Schoken Books | New York |
| Scribner | New York |
| Simon and Schuster | New York |
| Scholastic Trade | New York |
| Taunton Press | Newtown CT |
| Tor Books | New York |
| Thames and Hudson | New York |
| Touchstone Books | Westport CT |
| Vintage Books | New York |
| W.W.Norton | New York |
| Westview Press | Boulder CO |
+--------------------------+--------------+
28 rows in set (0.00 sec)
mysql> select*
-> from author;
+------------+-------------+--------------+
| Author_Num | Author_Last | Author_First |
+------------+-------------+--------------+
| 1 | Morrison | Toni |
| 2 | Solotaroff | paul |
| 3 | Vintage | vernor |
| 4 | Francis | Dick |
| 5 | Straub | Peter |
| 6 | King | Stephen |
| 7 | Pratt | Philip |
| 8 | Chase | Truddi |
| 9 | Collins | bradley |
| 10 | Heller | Joseph |
| 11 | Will | Gary |
| 12 | Hofstadter | Douglas R |
| 13 | Lee | Harper |
| 14 | Ambrose | Stephen E |
| 15 | Rowling | J.K |
| 16 | Salinger | J.D |
| 17 | Heaney | Seamus |
| 18 | Camus | Albert |
| 19 | Collins,Jr | bradley |
| 20 | steinbeck | John |
| 21 | Castelman | Riva |
| 22 | Owen | Barbara |
| 23 | ORourke | Randy |
| 24 | Kidder | Tracy |
| 25 | Schleining | Lon |
+------------+-------------+--------------+
25 rows in set (0.02 sec)
mysql> insert into author value
-> ('26','Jemes','Peter');
Query OK, 1 row affected (0.05 sec)
mysql>
No comments:
Post a Comment