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

Unable to join domain on Windows 10 [GUARANTEED FIX]

Emmanuel Johnson avatar. By: Emmanuel Johnson
2 minute read

Did you ever encounter Unable to join domain message on Windows 10? This can be a problem, but in today’s article we’ll show you how […]

Continue Reading

Quick Access deleted on Windows 10 [EXPERT FIX]

Tashreef Shareef avatar. By: Tashreef Shareef
2 minute read

The Quick Access feature in Windows 10 provides a convenient way to access your frequently opened folders and recently opened files. While some may find […]

Continue Reading

Gears of War 5 error 0x00000d1c is plaguing many gamers

Rabia Noureen avatar. By: Rabia Noureen
2 minute read

Many Gears of War 5 players who tried to join ranked matches reported experiencing different issues. They keep on getting error 0x00000d6e when they trying […]

Continue Reading