Insert the correct information in to the table

I have a few books in my possession with which I am going to fill up my table, you may not have the same books but you should be able to follow this section very easily as I will be explaining what I am doing in detail.

The first step of course is to get the information which is required, the first book that I am going to put into the table has the following details,

	`Book name'     = `Sams - Teach yourself MySQL in 21 days'
	`ISBN number'   = 0672319144
	`Price'         = 28.99
	`Date purchased'= `2000-06-05 13:05:00'

So now we need to put this information into our table, this is done using the `insert' command in MySQL (again reference to the manual for full syntax listing), this can be done using the following line;

        mysql> insert into books values ('Sams - Teach yourself MySQL in 21 days',
            -> 0672319144,
            -> 28.99,
            -> '2000-06-05 13:05:00');
        Query OK, 1 row affected (0.01 sec)

To see whether this made into our database we can use 'select' like so;

        mysql> select * from books;
        +----------------------------------------+------------+-------+---------------------+
        | bookname                               | isbn       | price | datepurchased       |
        +----------------------------------------+------------+-------+---------------------+
        | Sams - Teach yourself MySQL in 21 days | 0672319144 | 28.99 | 2000-06-05 13:05:00 |
        +----------------------------------------+------------+-------+---------------------+
        1 row in set (0.00 sec)

This shows us that the data has been entered into the database successfully. You can now enter the rest of your information into the database in the same manner, here is a copy of my table after I entered 5 books into the database;

        mysql> select * from books;
        +-----------------------------------------------+------------+-------+---------------------+
        | bookname                                      | isbn       | price | datepurchased       |
        +-----------------------------------------------+------------+-------+---------------------+
        | Sams - Teach yourself MySQL in 21 days        | 0672319144 | 28.99 | 2000-06-05 13:05:00 |
        | Photoshop Web Magic Volume 1                  | 1568303149 | 41.50 | 2000-07-01 09:21:00 |
        | The Chess-Players Handbook                    | 0713450568 |  9.99 | 1996-03-23 15:54:00 |
        | The Holiday Which? Guide To The Lake District | 0340488786 |  7.95 | 1994-12-15 10:43:00 |
        | lonely-planet - New York City                 | 0864425023 |  9.99 | 1999-02-05 17:35:00 |
        +-----------------------------------------------+------------+-------+---------------------+
        5 rows in set (0.01 sec)