Like always, I do an end-of-year round-up here on my blog. This year is no different in that aspect, although it has been one crazy year otherwise. With the holidays upon us, I look forward to much-needed time off work, spending time with my family, and catching up on some fantasy novel reading. With that said, here are this year’s top-5 most viewed blog posts from Digital Owls’ Prose. Ironically, for the second year running, none of them were actually written this year! Got to love that evergreen content right!?! Enjoy!
[Keep reading for more SQL database and PHP/Python-centric content >>>]Blog
MySQL Window Function Compilation
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…
[Continue reading for more PHP/Python/MySQL content >>>]ROW_NUMBER() Window Function – find duplicate values.
Many times, we do not want duplicate rows or values in our SQL tables. On the other hand, in some situations, it does not matter if there are duplicates present. For whatever reason, suppose duplicates have found their way into one of your tables. How can you find them quickly and easily? The ROW_NUMBER() Window function is a fantastic tool to use. Continue reading and see example queries you can apply to your own tables and find those duplicates…
MySQL Shell Python mode for multiple ALTER TABLE statements – easily
There may come a time you need to rename one or more columns in an existing MySQL table for a variety of reasons. Using ALTER TABLE, to rename a column is an easy enough command. But, suppose there are multiple tables in the same database/schema that have the same-named column and all of those columns need to be renamed. That could be a lot of ALTER TABLE statements to type out. Save your energy and time, avoiding all of those ALTER TABLE commands all-together. If you are lucky enough to be working with a MySQL version > 8.0 then the Shell is your salvation. With just a few lines of Python code in \py mode, all of your trouble(s) and headache(s) are no more…
MySQL EXTRACT() method for specific DATE and TIME values
Date and time values are some of the most important datatypes in an RDBMS. From tracking order dates to payroll hours, DATE and DATETIME datatypes are used in all types of applications. At times as a Developer, you may need only certain portions of a DATE or DATETIME value. In MySQL, the EXTRACT() function can provide you with a specific component of a DATE or DATETIME value depending on which INTERVAL is given as a parameter. Continue reading to see example EXTRACT() queries for understanding…