I want to know if this query I wrote for statistics is fast. It currently works in 3 seconds with the data and query I wrote below. Now I have a user table. Those whose role is Hr can create…
I have a DB that stores student records and there are 4 tables that I need to query from to get a student grade report. The tables being JOIN are school, students, subject, student_score, class The table structure are as…
TL/DR: What logic can I add to SELECT (-1816598198 << 8); to ensure that it returns -1192670720 like in JS/TS? Full Question: I'm having trouble porting a JS/TS function to MySQL. The function I have is: const BuildIDLookupTable = [0x00000000,…
I recently started exploring sql basics in oracle to help myself to work on a migration project where project is subject to migrate from Oracle platform to a different one; while trying to google for a concept, say for instance,…
Let's say if I'm making a website where I let people using emojis in their username, and I will have a table for each user to store their info/profiles/etc.., and the name of will be the same as their username.…
I have the following table in a MySQL 8.0 database (multiple fields left out of the table below) with a composite primary key that I cannot update using INSERT INTO ON DUPLICATE KEY UPDATE CREATE TABLE IF NOT EXISTS db.entries…
I have a table of Client and Product(that the client purchased) Client Product Alex A Alex B Alex C Alex D Peter A Peter B Peter C Aline C Aline D Aline E Aline F Aline G Joao B Joao…
I'm having duplicate values in a table which I'm able to fetch using the below sql - select p.*, j.job_id from ( select count(job_id) cnt, title, email, msg_no from ( select job_id, title, email, msg_no from job_posts order by job_id…
the selected values of my query are like gruppo-1_some_text gruppo-12_some_other_text But I'd like to have only some_text some_other_text So I would need to substract 'gruppo-d+_' from the initially selected strings. I don't have REGEXP_REPLACE and the like on mysql 5.7.39,…
I have an energy counter (kWh) recorded in a MySQL database every 15 minutes. Sometimes the recording fails for several reasons (power outage, computer reboot for updates...) and values are missing. The table looks as followed: id Time Energy 27800…