OpenLampTech has published another fantastic developer interview in the weekly publication.
(more…)Database Programming
OpenLampTech issue #90 – Substack Repost
Like always, there is so much great content online in any niche. I am trying to share all the good I can find in the MySQL, PHP, and LAMP stack landscapes. Thank you for reading OpenLampTech each week!
(more…)5 Websites To Learn More SQL – Substack Repost
SQL is foundational in web and application programming. There are many websites and resources online to learn SQL. I like these 5 websites and think you will too…
(more…)Simulate LEAD() Window Function using correlated subquery
In my honest opinion, MS Access is one garbage of a database. More likely, database is too strong of a word. While I won’t be using Access in this article, there is a story there (but I’m not here to have an Access bash party). Continue reading for an example of how you may use a correlated subquery and simulate the LEAD() Window Function.
(more…)INTERSECT and EXCEPT commands in MySQL
MySQL now supports the INTERSECT and EXCEPT set operators. Set operators work on the results of multiple SELECT statements. In this post, we will see example queries using INTERSECT and EXCEPT commands for a better understanding
(more…)