What is the syntax of modify statement in mysql database

Update statement is generally used in conjunction with WHERE to specify the conditions for the piece of data to be changed. Use UPDATE's SET to modify the specified field to the specified value.

The syntax is as follows:

(Video tutorial recommendation: mysql video tutorial)

For example: To modify Person The FirstName in the data table where LastName is equal to Wilson is Fred, and the SQL statement is:

UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'

Recommended tutorial: mysql tutorial

The above is the detailed content of What is the syntax of modify statement in mysql database. For more information, please follow other related articles on the PHP Chinese website!