SQL DELETE Query |¦| SQL Delete Command |¦| SQL Tutorial
81 هزار بار بازدید -
6 سال پیش
-
In SQL, the DELETE query
In SQL, the DELETE query is used to delete a row from a table. In this tutorial we will show you how to use the delete command to remove one or more rows from a table. The key is to carefully test your query and make sure your WHERE clause targets exactly those desired rows.
To do this, we will first write the DELETE query, comment it out using one of the two ways to write a comment in SQL, test the WHERE with a SELECT, then finally execute the DELETE.
The song data used in this tutorial can be downloaded from Github:
https://github.com/socratica/data
Our SQL playlist starts here:
↪http://bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ http://bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪http://bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : Patreon: socratica
► Make a one-time PayPal donation: https://www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: Facebook: SocraticaStudios
Instagram: Instagram: SocraticaStudios
Twitter: Twitter: Socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦
To do this, we will first write the DELETE query, comment it out using one of the two ways to write a comment in SQL, test the WHERE with a SELECT, then finally execute the DELETE.
The song data used in this tutorial can be downloaded from Github:
https://github.com/socratica/data
Our SQL playlist starts here:
↪http://bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ http://bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪http://bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : Patreon: socratica
► Make a one-time PayPal donation: https://www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: Facebook: SocraticaStudios
Instagram: Instagram: SocraticaStudios
Twitter: Twitter: Socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦
6 سال پیش
در تاریخ 1397/12/27 منتشر شده
است.
81,066
بـار بازدید شده