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

This article mainly introduces the method of batch modification of data by navicat, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Navicat is a very easy to use database management software, today we will show you how to use navicat to modify data in batches.

Using navicat to modify data in batches, we just need to select the table to be modified, then click on the query, create a new query, and enter the update statement in it to update the data. The updated content and which write data need to be updated can be set in the update statement.

The following is to introduce the definition and grammar rules of update.

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

Grammar

UPDATE table name SET column name = new value WHERE column name = a value

Person data sheet

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilson

Champs-Elysees

Update a column in a row

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

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

Result

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredChamps-Elysees

Update 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'

Results:

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredZhongshan 23Nanjing thank you for reading this article carefully. I hope it will be helpful for everyone to share the methods and contents of navicat to modify data in batches. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.