I have two tables, T1 which is the original table and the T2 which is an exact copy of T1 until I make changes for it. At the start both T1 and T2 looks as follows: ID Event Event_Date 001…
How can I convert my MySQL database to a Firebase database without rewriting the database? Is there a way of exporting to Firestore or Realtime database and I just change a few things in my PHP code? I am still…
We have a custom-built CRM system that's deployed on AWS RDS. Our FE and BE systems are JavaScript, and the database prohibits the JS devs from directly manipulating the database. They must go through predefined APIs or a controlled query…
I have a site that gets a lot of traffic this time of year (around 50,000 users a day). The traffic goes up every year and all the sites on my server are starting to crash more, apparently because of…
My hoster switches from MySQL 5.7 to 8.0.33 soon so ONLY_FULL_GROUP_BY is enabled by default then. I can't add ONLY_FULL_GROUP_BY already to the SQL mode for testing purposes right now because of missing rights. So it's also not possible to…
I want to identify and count uris that contain the following values ukpga ukla asp asc anaw mwa ukcm nia aosp aep aip apgb nisi mnia apni I have a column in the table that has a list of uris.…
With the following table: CREATE TABLE `Example` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `properties` json DEFAULT NULL, `hash` binary(20) GENERATED ALWAYS AS (unhex(sha(`properties`))) STORED, PRIMARY KEY (`id`), KEY `hash` (`hash`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; the column hash…
What is the difference, if any, in these two MySQL statements? Is there a performance difference if I use MATCH in the WHERE clause, or is it unnecessary? SELECT `column`, MATCH(`column`) AGAINST ("searchterm") AS `rank` FROM `table` ORDER BY `rank`…
I have following two tables which I would like to inner join based on part of each column content in both tables is equal to a value. In below example I would like to inner join two tables where I…
I have a table someone else built to track orders and they created a separate 'order_status' table but I just realized that they add a new 'status' record every time the status of an order in production changes, rather than…