Mysql – SQL Aggregate Over Range of Values
I have T1 which is formatted as STUDENT SCORE DATE 1 6 2022-02-01 1 0 2022-03-12 1 5 2022-04-30 1 1 2022-04-30 1 1 2022-05-14 1 1 2022-05-19 1 8 2022-05-26 2 9 2022-01-02 2 10 2022-04-11 2 2 2022-04-12…
Mysql – How to prevent adding duplicate values for two columns in SQL?
Essentially, I am wondering if there is a way to prevent adding duplicates for two columns. Consider a table with three columns, X, Y, and Z. I would like to be able to add entries with the same X value…
Best performance for mySQL and PHP: Lots of small queries, or a large one? – WordPress
So i have this technicall dilemma: I have a Wordpress site, with more than 50 categories (and rising). I want to get just the six categories with the newest article in them, and -if i get this right- i can't…
[mysql]: Querying more db data vs loop on large array
I need to compare few scenarios, which can be fulfilled either by calling: an additional timestamp column from mysql database or Looping over the resultant array. Elaborating further: CASE 1: 144 byte columns + 4 byte timestamp column for 10K…
Mysql – Choose the person who worked the most night shifts
How do you choose the employee who has worked the most night shifts of all time? There are 2 tables, one with workers, the second with night shifts, in which 2 people work per shift. Users: id name 1 Oliver…
LIMIT position for a query in MySQL
I am trying to run this SQL query SELECT activity_log.* from activity_log where activity_log.id in ( select a2.id from activity_log as a2 where a2.batch_uuid = activity_log.batch_uuid order by a2.id desc limit 1 ); I get the error ERROR 1235 (42000):…
Mysql – List all column names that are non-unique across tables
I have a need to know which column names are used on more than one table of my database. I've got this query as a start, which gives me a frequency table of column names across the database: SELECT COLUMN_NAME,…
MySQL DISTINCT date only returning 1 value for particular table. Same query works on other tables
I have 2 tables with the exact same structure: date (date) title (varchar 275) Both tables have rows for dates including 2021-01-01 to 2021-12-31 If I run this query on table1: SELECT DISTINCT date FROM table1 WHERE date IN ('2021-01-02',…
Mysql – SELECT tabA.*, tabB.* FROM … => Duplicate Column
I've got following tables: Supplier idSupplier Name Product idProduct idSupplier EAN Now I want to select all values from both tables. I'm using this Query: SELECT Supplier.*, Product.* FROM Supplier INNER JOIN Product ON Supplier.idSupplier = Product.idSupplier The issue is,…
Why does `getAllPermissions()` with where condition isn't working in Laravel?
I am working in larael9 with spatie package to manage roles and permissions. I want to fetch user permissions with where condtion. my permissions table is as following id | name | guard_name | created_at | updated_at ------------------------------------------------------------------------------------------------- 14 |…