Delete (SQL)

Gennaro avatar. By: Gennaro
Less than a 1 minute read

Home » Vocabulary » Thing » Delete (SQL)

In the database structured query language, the DELETE statement removes one or more records from a table. A subset may be defined for deletion using a condition, otherwise all records are removed. Some DBMSs, like MySQL, allow to delete rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE). Executing a DELETE statement can cause triggers to run that can cause deletes in other tables. For example, if two tables are linked by a foreign key and rows in the referenced table are deleted, then it is common that rows in the referencing table would also have to be deleted to maintain referential integrity.

Discussions

Next up

Users claim Microsoft still collects activity history despite being disabled

Giles Ensor avatar. By: Giles Ensor
3 minute read

Recent comments on Reddit would suggest that Microsoft is still not playing the game when it comes to collecting data on its users. This is […]

Continue Reading

4 Christmas gift ideas for dog lovers that are both practical and fun

Madeleine Dean By: Madeleine Dean
Less than a 1 minute read

So, you’re still looking for a nice Christmas present for your best friend? Well, if he/she is also a dog lover, look no further. In […]

Continue Reading

This is how we fixed ‘The Package could not be registered’ error

Sovan Mandal avatar. By: Sovan Mandal
3 minute read

Oftentimes, there is a rather weird The package could not be registered error message that shows up every time you try to open a .jpg […]

Continue Reading