I am super pleased to share that I have completed and uploaded my first (that I can share at least) personal portfolio piece written in PHP to a subdomain on my personal hosting server located at walk.openlamp.tech. Over the better part of the last year, I have developed a custom reporting dashboard written in PHP for my (current) employer, but do not share any of that work as it is proprietary and not owned by me. However, for a personal project, I can share far and wide. In this post, I provide a brief overview of my simple (in theory at least) application/site, built on the LAMP stack using the MVC (Model-View-Controller) design pattern in core PHP along with Bootstrap 4, jQuery, and MySQL.[Keep reading for more SQL database and PHP/Python-centric content >>>]
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
UPDATE statements. Continue reading to see
DELETE command examples for better understanding…
Some data may never change. Yet, other data will change. In SQL, you modify existing rows of data with the
UPDATE is a powerful command as it can potentially change multiple rows of data in a single execution – for better or worse.
UPDATE is categorized as a DML command which means: Data Manipulation Language. Let’s learn how to use this integral command with examples…
In SQL CRUD Basics Part 1 – Create, we learned how to create new rows of data in a database table with the
INSERT statement. In this post, we are going to visit the busiest statement in SQL –
SELECT. If you want to view or read the stored data in a table, you use
In Introduction to SQL CRUD Basics, I listed out the 4 elements of CRUD. Create is the first and the subject of this post. Create relates to the SQL
INSERT statement, which is used to introduce new rows of data into a database table. Continue reading to learn basic usage of this first CRUD element.