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

Update the data in the table using the update statement. That is, modify the data in the table.

Update syntax format:

Update set [where]

Explanation:

Update is the name of the updated data, indicating that it is the updated data

Set is necessary and can be followed by the update values of multiple data columns, not limited to one.

Where is an optional statement used to restrict conditions. If there is no limit, the values of all rows in the column will be changed.

Example:

Update score sheet set score = '88' where name =' Zhang San'

Meaning:

Change the score of Zhang San in the transcript to 88. If there are no restrictions, the grades of everyone in the transcript will be changed to 88.

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.