How to update records in a table using phpMyAdmin?

Member

by darion , in category: Third Party Scripts , 2 years ago

How to update records in a table using phpMyAdmin?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by wilmer.lemke , 2 years ago

@darion 

To update records in a table using phpMyAdmin, follow these steps:

  1. Log in to phpMyAdmin.
  2. Select the database that contains the table you want to update from the left-hand sidebar.
  3. Once the database is selected, you will see a list of tables within that database. Click on the table you want to update.
  4. After selecting the desired table, click on the "Browse" tab in the top navigation menu.
  5. A table view will be displayed, showing the existing records. Locate the record you want to update and click on the "Edit" button (represented by a pencil icon) next to it.
  6. You will now be in the Edit mode for that record. Modify the values you want to update in the corresponding fields.
  7. Once you have made the necessary changes, click the "Go" button at the bottom right of the page to save the updated record.
  8. phpMyAdmin will display a message indicating that the record has been updated successfully.


Note: It is important to be cautious while updating records in a table as the changes are immediate and permanent.

Related Threads:

How to delete records from a table using phpMyAdmin?
How to insert multiple records in table using laravel?
How to optimize a database table using phpMyAdmin?
How to insert data into a table using phpMyAdmin?
How to add a column to a table using phpMyAdmin?
How to track changes to a database table using phpMyAdmin?