SQL CRUD Basics Part 4 — Delete.

In this final part of the SQL CRUD Basics series, we visit the all-mighty and powerful DELETE command. Does that word frighten you? It should, as DELETE will completely remove rows of that oh-so-important data from your database table. Without warning or question, it will be gone. Perhaps your goal is to remove all rows. Great, no problem. However, removing a specific row or set of rows – instead of them all – requires filtering with a WHERE clause predicate, just the same as you would in SELECT and UPDATE statements. Continue reading to see DELETE command examples for better understanding…

--

--

--

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Weekly R&D update #1 Nov. 1–7

Basic physics in Unity

Let’s order a pizza in Go — Part 4

READ/DOWNLOAD$) Starting Out with C++: Early Objects (9th Edition) FULL BOOK PDF & FULL AUDIOBOOK

Build time in iOS

Collisions in Unity

Making a Reactive <select/> using Ruby and React

DAG ALGORITHM LOGIC

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Joshua Otwell

Joshua Otwell

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

More from Medium

INTRODUCTION TO SQL

Stored Procedures in MySQL

T-SQL :: DELETE All Data in Schema

Your SQL Server Colleagues

Introduction to SQL

Fig : Relational Database Design (source : researchgate.net)