I’ve once again published a massive issue of the OpenLampTech newsletter, the newsletter for PHP/MySQL developers. If you’re looking to learn more about PHP and MySQL, you’ve come to the right place…
Image by Clker-Free-Vector-Images from Pixabay
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the …
[Read more]I’ve been publishing more articles outside of the OpenLampTech newsletter, directly to the Substack page. In this post, I’m sharing a recent post featuring one of my favorite SQL books…
Image by Dariusz Sankowski from Pixabay
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the …
[Read more]
During many decision-making phases in programming code
(conditional logic), there are times execution depends on
several different factors. Multiple conditional tests
are powerful and constraining, oftentimes requiring more than one
test to be passed in order for program flow to proceed. For MySQL
(and standard SQL in general) the CASE expression is
used for IF/THEN/ELSE
conditional logic. The post, MySQL Simple CASE Expression – with
examples, covered Simple CASE queries which
are essentially equality tests. MySQL Simple CASE is
but one variant of 2, with the other being a MySQL
Searched CASE Expression. A MySQL Searched
CASE Expression can have multiple
conditional tests in each WHEN …
Programming logic is foundational in any application or piece of
software. Without it, software wouldn’t really do much of
anything. Everything happens off of choice. In the end, some
truthy or falsy value is what makes stuff work.
For IF/THEN/ELSE logic in
standard SQL, there is the CASE expression. There
are 2 variations of the CASE Expression: Simple and
Searched. In this post, I cover the Simple MySQL
CASE expression with example queries…
Image by Nika Akin from …
[Read more]
Be it running reports or displaying data in some other
visualization, SQL SELECT column expressions should
be meaningful and understandable. To provide those valuable query
results, SQL Developers, use a multitude of available functions,
adjacent columns, or other means not readily apparent to
end-users. All that being said, the column names often suffer the
most as far as readability is concerned, taking on long function
call names or other combined expressions. But, as luck would be
on our side, there is an easy fix and that is aliasing columns
using the AS keyword. Although AS is
optional – in this particular context – I err on the side of
readability and use it when aliasing SELECT column
expressions.
Any of you who read my blog posts here regularly know I am passionate about SQL, PHP, and Back-end Development. I consider writing an integral part of my brand and growth. Continue reading and learn more about what’s on my mind lately with writing and code…
Image by Arek Socha from Pixabay
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. …
[Read more]
Each SQL dialect is different in some way, shape, form, or
fashion from the next flavor. Some dialects have this
function, while others have that function. In this post, I cover
porting over Oracle SQL to MySQL in order to count the
number of occurrences of a specific weekday found in the current
given month (at the time of writing) purely as a learning
exercise focused on MySQL DATE functions and the
WITH clause…
Image by tigerlily713 from Pixabay
…
[Read more]Having spent the majority of this year programming a custom reporting dashboard for my employer written in PHP and MySQL, it is an understatement to say that I have learned a lot. Nothing beats real-world experience and I really have come into my own with PHP, learning more and more daily as I continue progressing forward on my goal of becoming a Back-End Web Developer. I have written several PHP-related posts this year and wanted to provide them all in one easy-to-access list. Enjoy!
Image by Aleksey Nemiro from …
[Read more]If you use SQL on a regular basis, then you are well aware that Window Functions are powerful. They allow us to simplify queries that would otherwise be quite the mess. We can provide meaningful insight across rows of data without collapsing the results into a single value. I have written numerous blog posts on Window Functions, many here recently. I decided to make this blog post a compilation of all the Window Function posts I have written, providing a one-stop source for any readers interested in learning more about Window Functions…
Image by Free-Photos from …
[Read more]
The Window Ranking functions: ROW_NUMBER(),
RANK(), and DENSE_RANK() each
rank rows with an increasing integer value. I wrote a
previous blog post, ROW_NUMBER() Window Function – find duplicate
values, where I covered how the ROW_NUMBER()
window function can be used to target any duplicate rows, with
the use of the PARTITION BY clause in the
OVER() clause. In this post, I cover the differences
between RANK(), and DENSE_RANK() in
handling any ties according to the sorting performed by the
ORDER BY clause with regards to the assigned
increasing integer. Continue reading and see examples…
…
[Read more]
