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

This article shares information about how Navicat deletes query data. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

If you want to use navicat to delete the query data, you can directly replace the select statement of the query with a delete statement, and replace the conditions of the query statement with the conditions of the delete statement.

DELETE statement

Delete statement is used to delete rows from a table.

syntax

REMOVE FROM TABLE NAME WHERE COLUMN NAME = VALUE

test data sheet

Person

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredZhongshan 23Nanjing

delete a row

"Fred Wilson" will be deleted:

DELETE FROM Person WHERE LastName = 'Wilson'

results

LastNameFirstNameAddressCityGatesBillXuanwumen 10Beijing

deleting all rows

You can delete all rows without deleting the table. This means that the table structure, attributes, and indexes are complete:

DELETE FROM table_name

Or:

Delete * From table_name Thank you for reading! About Navicat database delete query data method shared here, I hope the above content can have some help for everyone, so that we can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

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.