How to delete a record with the SQLDelete command

This article mainly introduces "how to delete records with SQLDelete command". In daily operation, I believe many people have doubts about how to delete records with SQLDelete commands. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts about "how to delete records with SQLDelete commands". Next, please follow the editor to study!

DELETE statement

TheDELETEstatementisusedtodeleterowsinatable.

DELETE declarations are often used to delete data from a table.

Grammar.

DELETEFROMtable_nameWHEREcolumn_name=some_value

Person:

LastNameFirstNameAddressCity

NilsenFredKirkegt56Stavanger

RasmussenNinaStien12Stavanger

How to use the SQLDelete command to delete a record

DeleteaRow

Delete a record

"NinaRasmussen" isgoingtobedeleted:

All personal information of "NinaRasmussen" will be deleted:

DELETEFROMPersonWHERELastName='Rasmussen'

Result

LastNameFirstNameAddressCity

NilsenFredKirkegt56Stavanger

DeleteAllRows

Delete all records

Itispossibletodeleteallrowsinatablewithoutdeletingthetable.Thismeansthatthetablestructure,attributes,andindexeswillbeintact:

You can delete all rows of records without deleting the data table. This means that the datasheet architecture, attributes, and indexes are preserved intact:

DELETEFROMtable_name or DELETE*FROMtable_name

At this point, the study on "how to delete a record with the SQLDelete command" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!