How to batch modify data in navicat

navicat is a very easy-to-use database management software. Today we will introduce to you how to use navicat to modify data in batches.

Recommended tutorial: navicat graphic tutorial

To use navicat to modify data in batches, we only need to select Select the table to be modified, then click Query, create a new query, and enter an update statement to update the data. The content of the update and which data needs to be updated can be set in the update statement.

The following introduces the definition and grammatical rules of update.

Update statement is used to modify the data in the table.

Syntax

##UPDATE table name SET column name = new value WHERE column name = some value

We add firstname for people whose lastname is "Wilson":

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

We will modify the address (address) and add the city name (city):

UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing'
WHERE LastName = 'Wilson'

The above is the detailed content of How to batch modify data in navicat. For more information, please follow other related articles on the PHP Chinese website!