Feb. 9, 2011, 1:41 a.m.
posted by romcheg
Manipulating Table Data
Since you've practiced executing a few SQL commands that manipulate database objects, you're ready to work with the data in your tables.
Naturally, you'll need to add rows to your tables. To add a purchase to your new purchases table, you'll use an INSERT statement in your query. Figure shows how this is done.
Using a predefined INSERT statement in insert.php
When you call up insert.php, in your browser, you get:
Figure shows that the new row made it to the database by selecting all rows from purchases.
Validating that our new row is in the database