University IT » Web Services » Help » MySQL » Updating Data
MySQL with phpMyAdmin Tutorial
Index | Getting Started | Tables | Viewing Data | Updating Data | Resources
Inserting and Updating Data
Inserting Data
- After selecting a database and table, click on the Insert tab.
- If your id field is set to auto-increment, you can leave it blank.
- If you have a field of type date time, you can set its value to the current date and time using the NOW function.
- Fill in the rest of the fields.
- Select either "Go back . . ." or "Insert another . . ." and press Go.
Editing a Single Row
- Find the row that you want to edit using either the Browse or Select tab.
- Click the edit link on the left of the row.
- Update any fields and press Go.
For More Advanced Updating:
Updating Multiple Rows (Using SQL codes)
- You can use the SQL tab to run UPDATE queries or any other query.
- Decide how to describe the data you want to update.
- This is the general form of a query:
- SELECT <fieldnames> FROM <tablename> WHERE <conditions>
- Test your description using a SELECT query, for example:
- SELECT id, firstname FROM people
- selects all rows in table people and displays only the contents of the id and firstname fields
- SELECT * FROM people
- displays every field of every row in table people
- SELECT id FROM people WHERE age > 21
- displays the id of each row whose's age field is greater than 21
- field age must be of type INT (integer)
- SELECT id FROM people WHERE age >= 40 AND age < 65
- displays the id of each row whose's age field is greater than or equal to 40 and less than 65
- SELECT id, firstname FROM people
- After pressing Go and viewing your selected data, edit your query by clicking on the edit link.
- Update the selected rows by editing your query:
- Replace the part of the query before the table name with UPDATE
- Before the WHERE clause, add a "SET" clause, for example:
- UPDATE people SET processed = 'yes' WHERE age = 18
- UPDATE people SET age = 19 WHERE age = 18
- "affected rows" text tells you how many rows modified.
