Learning PHP 7

Inserting data

We have created the perfect tables to hold our data, but so far they are empty. It is time that we populate them. We delayed this moment as altering tables with data is more difficult than when they are empty.

In order to insert this data, we will use the INSERT INTO command. This command will take the name of the table, the fields that you want to populate, and the data for each field. Note that you can choose not to specify the value for a field, and there are different reasons to do this, which are as follows:

• The field has a default value, and we are happy using it for this specific row
• Even though the field does not have an explicit default value, the field can take null values; so, by not specifying the field, MySQL will automatically ...