Subquery always has results in my query

I have two tables in MySQL: Table 1 - WORKORDERSID quantity 1221 Table 2 - ITEMSINWORKORDERSID work order 1121...

From [MySQLdiscussion group] 2023-09-11 22:06:01 0  1  523

How to use the same entity field in multiple entities?

What is the best way to have the same entity fields in many entities? For example, "Related Entities"...

From [MySQLdiscussion group] 2023-09-11 22:06:11 0  1  466

Get all the 1st data of the reference key in SQL

I have two tables called "Users" and "Payments". In Payment, there is a foreign key to the...

From [MySQLdiscussion group] 2023-09-11 21:36:51 0  2  486

Laravel get latest projects sorted by project end date

I need to write a scope to get items for the currently logged in user. If the currently logged in user has vie...

From [MySQLdiscussion group] 2023-09-11 21:38:55 0  1  506

Try wrapping the CASE/conditional statement inside a MySQL trigger

I have a trigger: CREATETRIGGERMovesAFTERINSERTONRollsFOREACHROWUPDATEPlayersCASEWHENP_Location+NEW.Rolls<1...

From [MySQLdiscussion group] 2023-09-11 20:55:31 0  1  979

Count the number of "registered" entries with a "purchase" event within X days of the registration date (grouped by date)

I have a table like this: id timestamp email ip event 12021-07-1500:01:00demo@demo.com11.11.11.11 registration...

From [MySQLdiscussion group] 2023-09-11 19:48:31 0  1  628

Join 3 tables referencing table 1 in MYSQL and combine values ​​with comma separator

I have a problem joining three tables. First try to join two tables is successful but on third table the resul...

From [MySQLdiscussion group] 2023-09-11 19:18:28 0  2  527

Rewrite the title as: If data is already inserted or not inserted into table A in MySQL, insert an id from table A into table B

I've been coding for about a year now and I'm currently working on a portfolio (a recipe website) but I'm stuc...

From [MySQLdiscussion group] 2023-09-11 19:14:37 0  1  543

Why doesn't innodb store row pointers in secondary/non-clustered indexes?

As we all know, innodb only stores the primary key value in the secondary index, which means that we need to t...

From [MySQLdiscussion group] 2023-09-11 17:28:42 0  1  606

SQL query results are 0 when the string in the database row has a special font

I'm running this query: SELECTidFROMpostsWHEREtitleLIKE '%CERTIFIEDINSTALLER%'; The text in the database is st...

From [MySQLdiscussion group] 2023-09-11 16:04:04 0  1  584

How to sum multiple columns of data from multiple tables in mysql?

I have 4 tables: 1 - Supplier ID_A Supplier Name 1 Apple 2 Xiaomi 3 Nokia 4 OPPO 2 - Starting Balance ID_B Sta...

From [MySQLdiscussion group] 2023-09-11 15:48:19 0  1  564

Set primary key column name when using multiple foreign keys

createtableteach_enroll(instructor_idvarchar(64)notnull,class_idvarchar(64)notnull,course_idvarchar(64)notnull...

From [MySQLdiscussion group] 2023-09-11 15:27:20 0  1  477

"Sum(if) grouping in MySQL"

I have the following table which is not loading: Payment Date, User Id, MonthlyAmount_last30d User ID and Paym...

From [MySQLdiscussion group] 2023-09-11 13:16:22 0  1  447

Sorting mysql results by two columns, but with a "hole" column

My initial situation is as follows: +----------------+-------------+|legacyRank|forcedRank|+---------- --+----...

From [MySQLdiscussion group] 2023-09-11 12:14:50 0  1  413

SQL - Basic Inner Join Query

I have 3 MySQL tables and I want to join them together. Course: CREATETABLE`library_classes`(`id`intNOTNULLAUT...

From [MySQLdiscussion group] 2023-09-11 11:02:31 0  1  565