Home » Programming
How to Update Records – MySQL UPDATE Statement
This article will show you how to use the MySQL/MariaDB UPDATE statement to update existing database records. MySQL/MariaDB UPDATE Syntax The syntax for the MySQL UPDATE statement requires the use of two keywords, UPDATE, and SET, and is as follows: UPDATE table SET column = value WHERE conditions; Note that: table is the name of the table which contains the records to be updated column = value defines which column to update and what the new value for that column should be Multiple column/value pairs can be defined, separated by a … Read more