MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Learn about a MySQL feature that could be useful in some scenarios for SQL Server.
2025-11-10
4,235 reads
MySQL
How to Repair Corrupt MySQL Tables
In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster recovery. MySQL is one of those database platforms which provides a lot of features and high performance. Just […]
2024-12-27
1,317 reads
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.)
2024-01-05
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-04
329 reads
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-02
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.
2023-06-07
142 reads
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.
2023-06-07
How Snowflake Creates and Detects Deadlocks
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.
2023-05-29
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
2023-05-26
1,008 reads
Retrieving MySQL data from within Python
The approach you take when accessing MySQL will depend on the programming language you’re using and the connector you choose for interfacing with the database. Whatever approach you take, the same basic principles generally apply to each environment. You must establish a connection to the database and then issue the commands necessary to retrieve or modify the data.
2023-05-24
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?