I'm running Spring Authorization Server in production with MySQL 8.4 on AWS RDS. Our oauth2_authorization table has accumulated around 600,000 records, and we're experiencing significant performance ...

SELECT tt.trans_type_name AS transaction_type, trans.transaction_time, a.trans_action_name AS transaction_action_name, trans.transaction_notes FROM(SELECT Cast(...

This one is a bit of a double question, I am creating a database for an assignment on SQL. I'm making some tables, the code for the two I need help with listed below. For my bookings table, I need the ...

We’re working with a user table populated from multiple SSO sources, and the data has inconsistencies that hinder generating standardized names. I need a persistent, automated way to extract and ...

I am working on a table where compared data of colleges have been stored. But facing difficulty to query data in low response time. I am creating an API to get some analytics data within 300ms but a ...

I am designing a DB where basically parent can't exist without two children. E.g: Entity set Marriage, CAN'T exist without entity set Man and entity set Woman, but neither Man or Woman need Marriage ...

A user I'm supporting is getting the error. The user has grants to various tables in mydb, but when he tries to access them, he gets the error: Access denied for user 'myuser'@'myhost' to database '...