Eliminate records by grouping and aggregation

I have a temporary table with the following content: playlist_id|item_id|passed-------------------------------...

From [MySQLdiscussion group] 2023-08-17 19:20:03 0  1  326

MySQL, add column 'FullNameReverseOrder' with data from fullname column and change (FName, LName) to (LName, FName)

I want to add a new column named FullNameReverseOrder to a table named NameTable, where the information of Ful...

From [MySQLdiscussion group] 2023-08-17 17:32:04 0  1  536

When using EF Core to query MySQL in C#, the primary key column name is incorrect

I'm learning how to query a Mysql database in C# but I'm getting an error saying there is an invalid column in...

From [MySQLdiscussion group] 2023-08-17 13:45:14 0  1  589

MySQL, check if foreign key is assigned to any table

I have a table called files. Additionally, I have more than 100 tables in which I use association/foreign key ...

From [MySQLdiscussion group] 2023-08-17 12:51:10 0  1  526

Get records of employees who took 11 consecutive days off

I have an attendance record with fields for employee number, status and attendance date. I want to use SQL que...

From [MySQLdiscussion group] 2023-08-16 20:44:15 0  1  493

What is the best way to connect Flutter with a MySQL database?

How to connect Flutter to a MySQL database is the best way, is it safe to put the connection string in it, and...

From [MySQLdiscussion group] 2023-08-16 17:38:23 0  1  648

C# standalone application remote access MySQL directly to hosting server

From what I understand, I've done a lot of research on Putty, SSH, DDNS, etc. to connect the dynamic IP of my ...

From [MySQLdiscussion group] 2023-08-16 15:15:37 0  1  555

How to use cursors to extract data from multiple tables

I have a query that returns multiple tables, something like this: SELECTTableName,DatabaseName+'.'+TableName,C...

From [MySQLdiscussion group] 2023-08-16 13:12:27 0  2  574

When using the fetch object in PHP, the while loop cannot be used to take effect

I'm making a login page for the admin, but the while loop in the php code is not working. I'll leave the code ...

From [MySQLdiscussion group] 2023-08-16 11:49:58 0  1  557

Update React frontend data to reflect changes to MySQL server

I'm currently working on a web application using React to build the frontend and SpringBoot to build the backe...

From [MySQLdiscussion group] 2023-08-16 00:03:49 0  1  525

Inconsistent MySQL query results

I have a table called "transaction" that holds transactions made on a certain payment system. I want...

From [MySQLdiscussion group] 2023-08-15 21:47:39 0  1  513

Laravel query fails but same code works in PhpMyadmin

This is the code for my Laravel application: publicfunctionsendNotifications(){$matchingSubscriptions=DB::tabl...

From [MySQLdiscussion group] 2023-08-15 17:54:08 0  1  455

To find the student number of the student with the highest average score, how to write a SQL query to associate the grades with the student table?

This is my student table stud table rollnoname1A2B3C4B5D6C This is my grades table marks table rollnomarengmat...

From [MySQLdiscussion group] 2023-08-15 15:11:01 0  1  571

Solve the problem that Laravel cannot detect the "username" input

I'm new to laravel and my code was working before but I changed "name" to "username" and t...

From [MySQLdiscussion group] 2023-08-15 14:50:48 0  2  455

Multiple meta_values ​​use the same meta_key to query posts' custom fields

Scenario: A post has multiple entries with values ​​for the same key, for example a single post will have mult...

From [MySQLdiscussion group] 2023-08-15 14:16:16 0  1  703