Books for you

. .
INSERT INTO events (play_id, event, time) VALUES(0, 'Built DC', 2146.8);
INSERT INTO events (play_id, event, time) VALUES(0, 'Built MC', 27867);
INSERT INTO events (play_id, event, time) VALUES(0, 'Built PR', 65349);
INSERT INTO events (play_id, event, time) VALUES(0, 'Went Public', 86104);
INSERT INTO events (play_id, event, time) VALUES(1, 'Built DC', 8466.0);
INSERT INTO events (play_id, event, time) VALUES(1, 'Built MC', 29454);
INSERT INTO events (play_id, event, time) VALUES(1, 'Built PR', 57896);
INSERT INTO events (play_id, event, time) VALUES(1, 'Went Public', 79587);
INSERT INTO events (play_id, event, time) VALUES(2, 'Built DC', 31455.6);
. . .
You can create the database using the following command:
mysql -u your_username -p your_mysql_password
As you can see from Listing 3-3, the schema in this example is quite similar to the
previous schemas, except that it gives a bit more information. Each time a game is
played, there is an entry in the plays table. Every time a major game event happens, there
is a row in the events table.


Pages:
56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80