If you need a structure only .sql file of a MySQL tables’ Data Definition Language (DDL), phpMyAdmin makes this super-easy with just a few clicks. Continue reading and learn how…

Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others…


The SQL DELETE command is used to remove existing data from a database table.

Perhaps you want to remove all the data. An unfiltered DELETE will do just that (Be careful!!!).

On the other hand, maybe you need to be more selective in which row(s) to remove. That’s where DELETE


Data seldom remains unchanged. Applications manipulate data that is in constant change.

Users change profile information. Managers assign or reassign projects to employees. Bank accounts are updated with withdrawals and deposits.

You get the picture.

Data is constantly changing.

Image by Arek Socha from Pixabay

Are you a Medium member? If so, receive a notification by…


In the post, CodeIgniter 4 CRUD Series with MySQL: Create, I covered creating new rows of data in a MySQL database table using the CodeIgniter\Model built-in insert() method. There was quite a lot of boilerplate needed for setup to get the project off the ground and running.

This second post…


CRUD operations — Create, Read, Update, and Delete — are integral in any application in which data persists. Introducing a new row or rows of data is under the domain of Create and will be covered in this post.

CodeIgniter 4 is a powerful PHP web development framework that enables…


Do you need the same table structure as an existing table in your database, but empty of rows? Oracle SQL’s CREATE TABLE AS statement achieves this easily. Continue reading and learn how with a simple example…

Self-Promotion:

If you enjoy the content written here, by all means, share this blog…


Digital Owl’s Prose

One of the most universal data interchange formats in the world is the CSV file. Data professionals use CSV’s without a thought. Equally, those not even in the ‘ data field’ use CSV’s on a daily basis. Do you have the SQL query results for that report and need to…


At some point in the programming workflow, you have to work with character and text data. I’m sure some languages are better at parsing strings than others. However, most all programming languages have constructs or functions available for processing string data. …


If you are working with SQL relational databases, at some point you are going to use JOINs. Normalized data is organized and spread across multiple tables, oftentimes linked by a common column key (or multiple keys). We use JOINs to bring the data together. Therefore JOINs are an important concept…


Many of you may know that I am an avid walker. I enjoy walking and hiking for the health and mental benefits. I’m also finicky about the footwear I wear on my walks. I recently used the LEAD() Window function on some of the walking data I track and discovered…

Joshua Otwell

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging my journey and passion at https://joshuaotwell.com

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