Go to the previous topic.    Go to the next topic.

Inserting rows

The rows of a table store its actual information (data). Adding rows into a table is similar to adding rows into a spreadsheet.

To insert a row:

  1. Select the table into which you want to insert a row. If you have just created the table structure, the table will be preselected. To work with a different table, select it from the list of tables (in the left pane of the phpMyAdmin interface).
  2. Click the Insert tab.
  3. Enter values for the each column in the row. If a column is set to auto_increment (for example, if you are using a numbered ID field) leave the column blank.
  4. Click Go to add the row or Reset to clear the values you entered and try again.
Note: To continue inserting rows without returning to table structure view, select the Insert another row radio button before clicking Go.