MySQL Tutorial: Managing MySQL data

Insert Into SQL - Add Data

You can view your work by clicking people, and then the browse tab.

A quicker way is to add in data from the query window (click the SQL icon in phpMyAdmin) or a command line by typing:

INSERT INTO people VALUES ( "Jim", 45, 1.75, "2006-02-02 15:35:00" ), ( "Peggy", 6, 1.12, "2006-03-02 16:21:00" )

This inserts the data directly into the table "people" in the order shown. If you are unsure what order the fields in the database are, you can use this line instead:

INSERT INTO people (name, date, height, age) VALUES ( "Jim", "2006-02-02 15:35:00", 1.27, 45 )

Here we first tell the database the order we are sending the values, and then the actual values.

• Insert Into SQL - Add Data
• SQL Update Command - Update Data
• SQL Select Statement - Searching Data
• SQL Delete Statement - Removing Data