Showing entries 11 to 20 of 43474
« 10 Newer Entries | 10 Older Entries »
MySQL InnoDB: Primary Key always included in secondary indexes as the right-most columns… or not

Recently during the Swedish MySQL User Group (SMUG), I presented a session dedicated to MySQL InnoDB Primary Keys.

I forgot to mention a detail that many people are not aware, but Jeremy Cole has pointed out.

Primary Key always included in secondary indexes at the right-most column

When we define a secondary index, the secondary index includes the Primary Key as the right-most column of the index. It’s silently added, meaning that it’s not visible but it’s used to point back to the record in the clustered index.

This is an example with a table having a Primary Key composed of multiple columns:

CREATE TABLE `t1` (
`a` int NOT NULL,
`b` int NOT NULL, 
`c` int NOT NULL,
`d` int NOT NULL,
`e` int …
[Read more]
MySQL Shorts - Episode #56 Released

Episode #56 of MySQL Shorts in now available!

Using the Oracle Cloud TypeScript SDK Part 1 - Listing MySQL HeatWave Instances

Oracle offers a variety of SKDs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to list the MySQL HeatWave instances for a given compartment.

Unveiling the Highlights: A Look Back at MySQL Belgian Days 2024

Recap of the MySQL Belgian Days 2024

Three common MySQL database design mistakes

Learn about a few common mistakes when designing your MySQL database schema.

Considering Alternatives for Your MySQL Migration? Why Percona Should Be Your First Choice

You know about MySQL; we know about MySQL. After all, it’s been the most popular database system for years now. And now that we have that out of the way, on to the more important stuff!Because MySQL is so popular, you might be considering migrating your database to MySQL Community Edition or MySQL Enterprise. If […]

Can Disk Space Be Saved in MySQL by Adding a Primary Key?

Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). Such a requirement is imposed through two replication methods, though: Group Replication and Percona XtraDB Cluster (PXC), where using tables without a primary key is not allowed by default. There are many […]

Introducing Bring Your Own Certificate (BYOC) in MySQL HeatWave Service

By default, all MySQL connections are secured through a MHS-defined certificate. BYOC extends the service by allowing users to select their own certificates to be used by the MySQL Server. With a few clicks, you can now set up your secured connections for MySQL HeatWave Service. The service facilitates both mutual TLS (requiring a connection wallet for the client) and one-way TLS, allowing clients to connect without necessitating a wallet.

MySQL HeatWaveJP User Group Meetup on Feb 15

HWJP meetup 2/2024

Newsletter Repost – OpenLampTech issue #116

SheetDB API for Google Sheets | SQL execution order | WordPress ACF big update | Do you need foreign keys | WordPress plugin git repo set up.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Be sure you’re subscribed to OpenLampTech so you don’t miss out on any of the content each week.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, just because …

[Read more]
Showing entries 11 to 20 of 43474
« 10 Newer Entries | 10 Older Entries »