The MySQL DATE() function is a built-in function you use to extract just the date portion from a DATE or DATETIME value. Learn how to use the DATE() function in this blog post…
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 OpenLampTech newsletter.
MySQL DATE() Function Syntax
The …
[Read more]Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7 and 8.0, consisting of MySQL-wsrep 5.7.37 (release notes, download) and MySQL-wsrep 8.0.28 (release notes, download) with Galera replication library 3.37 (release notes, download) implementing wsrep API …
[Read more]The Galera Cluster Enterprise Edition
Codership is pleased to announce the Galera Cluster Enterprise Edition.
Galera Cluster Enterprise Edition consists of an enhanced Galera Cluster server, Galera Manager and Galera Load Balancer.
The enhanced Galera Cluster Server includes
1) A new Online Schema Upgrade method called Non Blocking Operations (NBO), adds more high availability to your cluster while performing schema changes.
…
[Read more]I recently took some time to explore the MySQL GROUP BY WITH ROLLUP modifier. As a self-starter, I’m always unknowingly studying SQL concepts that I soon need for a query requirement. Call it luck or premonition, doesn’t matter to me. I’ll take these small wins thanks to my curiosity…
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 OpenLampTech newsletter.
I went for a deep dive into the WITH ROLLUP GROUP BY modifier over on the OpenLampTech publication page.
Read the article, …
[Read more]Codership is pleased to announce a new release of Galera Manager. This is version 1.6.2 of Galera Manager GUI. Users will notice many usability improvements, and multiple fixes for issues filed at the galera-manager-support issue tracker.
The biggest user facing feature is now being able to deploy Galera Manager managed nodes on DigitalOcean, in addition to Amazon Web Services (AWS) Elastic Compute Cloud (EC2). Now with an access token, one can fully deploy a managed cluster from within Galera Manager. 3 node fully managed Galera Clusters on Digital Ocean in under 10 minutes? This is the promise and delivery of the latest Galera Manager.
From a security standpoint, SSL …
[Read more]Being mindful of NULL values is a good practice. NULLs can slip up on you and give you a heck of a time (especially in calculations) if you aren’t careful. In this post, we will see examples of NULLtransformation with the MySQL COALESCE() function.
Do you want to learn how to use MySQL but are not sure of where to start? I am creating premium MySQL Beginners content to help anyone understand the basics of using MySQL. Get a short, actionable email tip each week and more information on the premium articles and content as they are released.
[Read more]Honestly, if no one ever read the OpenLampTech newsletter, that’s fine because I always do! Hey everyone, here is your dose of PHP/MySQL content to help you learn, grow, and maintain your sanity for the week. Enjoy!
Image by Click on , consider Thank you! 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 …
[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]Supercharge your productivity in MySQL Workbench with these ‘click and paste’ SQL code snippets available for any table in a schema. Continue reading and see the ‘Staple Five‘…
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
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. Since coffee is my favorite drink, you can even buy me …
[Read more]This week’s issue of OpenLampTech, the newsletter for PHP/MySQL developers is once again loaded to the brim with the best content I can curate for your reading pleasure. I absolutely enjoy running and sharing the newsletter and I hope you are enjoying the content just as much. Thank you!!!!
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
[Read more]
