MySQL Database Service supports easy live migrations from an on-premises MySQL 5.7 database to MySQL Database Service.
Jan
31
2023
Jan
31
2023
MySQL REST Service The MySQL REST Service (MRS) enables fast and secure HTTPS access for your MySQL data. Implemented as a MySQL Router feature, MRS provides the ability to publish RESTful Web Services for interacting with the data stored in MySQL solutions. MySQL Shell for VS Code offers an intuitive way to configure MRS and create RESTful […]
Jan
30
2023
With so much content online today, how do you find the ‘good stuff’ for a certain topic? While I can’t answer for other niches, if you’re interested in MySQL, PHP, and the LAMP stack, well, you already know the answer. Thank you for reading OpenLampTech!
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.
In OpenLampTech issue #63, we are looking at great content covering:
- WordPress robots.txt file
- Preventing SQL injections
- 10 books for PHP developers
- Large MySQL tables
- And much much more
I …
[Read more]
Jan
27
2023
Announcing MySQL Shell 8.0.32
Jan
27
2023
While MySQL error codes are useful, understanding what they mean can be difficult. This article looks at common MySQL error codes, non-coded errors, and how to fix them. MySQL error code format Each MySQL error includes: An error number: A MySQL-specific number corresponding to a particular error. An SQLSTATE value: A five-character string that indicates the error condition. An error message: A textual description of the error. MySQL error example Here’s an example of what a MySQL error code looks like:ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist
In the error above: 1146 is the error number. 42S02 is the SQLSTATE value. Table test.no_such_table doesn't exist is the error message. Common MySQL error codes Let’s explore some common error codes, what they mean, and how to resolve them. Error 1040: Too many connections Error 1040 occurs when MySQL reaches the maximum number of client connections, forcing you to close …
[Read more]
Jan
27
2023
An overview of some common MySQL error codes you may run into what they mean and how to solve them.
Jan
26
2023
MySQL HeatWave is an extremely powerful Online Analytical Processing (OLAP) engine for MySQL on OCI. Analytic SQL queries that would normally takes hours can be executed in minutes and therefore MySQL HeatWave can help to save a lot of time, processing power and cost. Wouldn’t it be great if a developer of an OLAP application could directly […]
Jan
26
2023
This blog post shows the benefits of using MySQL Shell for VS Code when working with a MySQL HeatWave instance.
Jan
26
2023
Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic.
A bug appeared in MySQL’s recently released 8.0.32 that really caught my attention. This is a prime example of how a minor bug could have a significant impact on your life and a detrimental impact on your company or project.
The title Wrong result for AVG() OVER(ROWS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING) is the first thing that caught my eye. A lot of developers heavily use the AVG() function. My first thought was, ‘ut-oh, AVG() being broken is a terrible thing,’ but then I realized it was thankfully not that drastic.
The OVER() clause indicates this is a problem in a Window Function. And odds are, if you are using OVER() for …
[Read more]
Jan
26
2023
Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist.