Conditional logic is integral for just about any application. Most programming languages support some form of if/else construct. MySQL is a dialect of SQL, which is a declarative language. But, it also includes support for conditional flow as do other languages such as Python, PHP, and Java. In this blog post, I will look at the IF() Function for similar if/else type of functionality.[Head this way for more great MySQL blogging >>>]
DML or Data Manipulation Commands should be handled with utmost care in SQL for the simple reason they modify the targeted data in some way. Typically, this is via
DELETE statements. In this blog post, we will learn how to better protect the data (and ourselves) when running these types of commands by utilizing a
SAVEPOINT within a
If you have read any of my blog posts, chances are you have seen many times where I have mentioned that typically there are multiple ways to achieve needed outcomes and results in SQL.
Maybe you need a total count of rows returned from a particular query’s results set? There are a myriad number of means to get that result.
However, it just so happens MySQL has a function that will determine the count of rows and return it (the number) for you. Honestly, I was not aware of it until a reader brought it to my attention.
What do I do? Dive right in and learn about it.
You may as well join me…
MySQL has a number of available String Functions, allowing you to work with string data values in a multitude of ways. In this blog post, I explore and learn about the
REPLACE function, used to replace specific sections of a string…
I visit Stackoverflow from time to time, curious about problems and issues plaguing developers, similar to my own. More importantly, I am drawn to the answers provided by the community to those problems. Recently, I read a question I was not 100% sure of the solution myself. Trust me, this is the case more often than not (haha). Perfect! Another opportunity to learn something new and here I am, sharing it with y’all…