Shulou(Shulou.com)06/01 Report--

Update update statement, usually used in conjunction with WHERE, specifies the condition of the piece of data to be changed, and uses the SET of UPDATE to modify the specified field to the specified value.

The syntax is as follows:

For example, to modify the FirstName in the Person data table where LastName equals Wilson, the Fred,SQL statement is:

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

These are the details of what the syntax of the modification statement is in the mysql database. Please pay more attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.