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

person data table

##LastNameGatesWilson##Update one of the rows Column

FirstName	Address	City
Bill	Xuanwumen 10	Beijing
	Champs-Elysees

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

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

Result

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredChamps-ElyseesUpdate several columns in a row

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

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

Result:

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredZhongshan 23Nanjing

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!