Hello Developers, In this tutorial we will discuss MySQL UPDATE Query Syntax with Example [Update Query in MySQL]. You can use this query and update your database row or column data. I will explain the update process from MySQL/phpMyAdmin, Command Prompt and by using PHP. So, you can understand the process and use it on your project. Just keep reading this tutorial.
First of all, let’s start with syntax.
MySQL UPDATE Query Syntax
The following syntext is used to modify the data in MySQL.
UPDATE table_name SET column1 = 'value1', column2 = 'value2', column3 = 'value3',... WHERE column_name = value
- Replace your table name with table_name.
- You can update multiple column values after SET. Like: column1 = ‘value1’, column2 = ‘value2’,…
- This query is affect only one table.
- Where condition is used to specify the column or row value which you want to update.
Update Query in MySQL from phpMyAdmin
You can fire the update command from phpMyAdmin. Just follow the steps below.
Go to phpMyAdmin
First of all, login to your cpanel and click the phpMyAdmin. Then you have to click SQL tab at the top-center of the page. See the screenshot below.
Next step is to write update query inside the textarea and click “Go”. When you click “Go” the query will fire and update your data.
UPDATE query in PHP
You can fire MySQL UPDATE Query inside the PHP function. The following example code will show you how to write update query in PHP.
- Fix database connection.
- Write the update query and execute it.
Above all code will update the name as “John Patel” where id is quual to 1.
Update using Command Prompt
You can update database value using command promt. I will show you how you can do it. Read following instructions.
root@host# mysql -u root -p password; Enter password:******* mysql> use Database_Name; Database changed mysql> UPDATE table_name -> SET name = 'John Patel' -> WHERE id = 3; Query OK, 1 row affected (0.04 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql>
You can use above all methods to update your database from MySQL. Also, you can use the PHP method to update query in MySQL and update your forms.
I hope this tutorial will help you. Share it if you like it.