Most developers use some form of auto-incrementing integer counter for a given database table, ensuring uniqueness among the rows. Several of the popular SQL dialects implement this facility. For instance, MySQL’s AUTO_INCREMENT attribute is used to provide a unique identity for a table row. What exactly is the behavior of AUTO_INCREMENT? Can you explicitly use a value of your choosing for it if you need to? How does it count? Continue reading and know the answers to these questions and more…
SQL
Import CSV file with MySQL Workbench
CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBA’s and Developers. Continue reading to learn how easy it is using MySQL Workbench…
[Keep reading for more SQL database and PHP/Python-centric content >>>]PHP portfolio piece – Analytics data.
I recently published a blog post about a portfolio project I am developing using the LAMP stack, Bootstrap 4, jQuery, and the MVC (Model-View-Controller) design pattern in core PHP. In this post, I will introduce an additional feature I integrated into the existing project.
[Keep reading for more SQL database and PHP/Python-centric content >>>]Digital Owl’s Prose End of Year blog post compilation
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 >>>]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 >>>]