Database Reference
In-Depth Information
This should show a successful execution, as in Figure 4-3.
Figure 4-3.
Adding multiple rows with a single INSERT statement
Now if you want to execute the following
SELECT
statement, you should see the four rows with an
auto-incremented ID value, going from 1 to 4. In other words, the first record will be 1, and each record
inserted after that will be incremented by 1. See Figure 4-4.
