Home >Database >navicat >How to delete query data in Navicat database

How to delete query data in Navicat database

angryTom
angryTomOriginal
2019-08-15 16:09:018422browse

How to delete query data in Navicat database

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

Recommended tutorial: navicat graphic tutorial

##DELETE statement

The DELETE statement is used to delete rows from a table.

Syntax

DELETE FROM table name WHERE column name = value


Test data table

Person

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredZhongshan 23Nanjing

Delete a row

"Fred Wilson" will be deleted:

DELETE FROM Person WHERE LastName = 'Wilson'

Result


LastNameFirstNameAddressCityGatesBillXuanwumen 10Beijing
##Delete all rows

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

DELETE FROM table_name

or:

DELETE * FROM table_name

The above is the detailed content of How to delete query data in Navicat database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn