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

Xiaobian to share with you how to use the delete statement in navicat, I believe most people still do not know how, so share this article for everyone's reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

navicat wants to delete data that meets certain conditions. delete from table name where condition 1 and/or condition 2.

How to use the delete statement.

SQL DELETE statement

Delete statement is used to delete rows from a table.

syntax

DELETE FROM table_name WHERE some_column=some_value;

Notice the WHERE clause in SQL Delete statements! The WHERE clause specifies which record or records need to be deleted. If you omit the WHERE clause, all records will be deleted!

example

In this tutorial, we will work with sample databases.

The following data is selected from the "person" table:

LastNameFirstNameAddressCityGatesBillXuanwumen 10BeijingWilsonFredZhongshan 23Nanjing

delete a row

"Fred Wilson" will be deleted:

DELETE FROM Person WHERE LastName = 'Wilson'

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 Above is "How to use delete statement in navicat" All the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.