How to get specific rows from table using "group by" and "order by"

I have a table like this: tmp_id product availability (0 and 1) is_available (0 and 1) stock_count (integer) p...

From [MySQLdiscussion group] 2023-09-12 17:54:20 0  1  496

SQL; How to write an "Order By" statement that switches as soon as the first match is found

I apologize if this question has been asked before. This is my original form. Username User Type Team Benjamin...

From [MySQLdiscussion group] 2023-09-12 17:25:22 0  1  486

python MySQL not saving to my database table

importMySQL.Connectordb2=mysql.connector.connect(host="localhost",port="3306",user="r...

From [MySQLdiscussion group] 2023-09-12 17:01:49 0  1  556

The JSONArray field of the Spring Boot returned model is empty

I have a JSONArray field in the object: @Column(name="_history",columnDefinition="JSON")@C...

From [MySQLdiscussion group] 2023-09-12 15:56:44 0  1  664

Error 1064 encountered while creating MySQL stored procedure

I want to create a stored procedure in MySQL, but I encountered an error 1064: Error code: 1064 Your SQL synta...

From [MySQLdiscussion group] 2023-09-12 15:41:52 0  1  619

Solve mysql CREATE TABLE syntax questions

I try to create a table in mysql using the following command: CREATETABLEkeys(idINT(10),keyVARCHAR(100)); but ...

From [MySQLdiscussion group] 2023-09-12 15:19:08 0  2  573

Corrected title: Explaining the "Truncated incorrect DOUBLE value" error in MySQL Connector with Python and providing ways to fix it

The first error message: mysql.connector.errors.DataError:1292(22007): Truncated wrong DOUBLE value: \--------...

From [MySQLdiscussion group] 2023-09-12 14:51:28 0  1  607

Select rows grouped by date

I want to select the headers (and ID-s) from a table grouped by date but like below. The cell on the left is t...

From [MySQLdiscussion group] 2023-09-12 13:45:48 0  1  617

Yii2 dropdown list value not persisted to database

I created a model called AssignForm: <?phpnamespaceapp\models;useyii\db\ActiveRecord;classAssignFormextends...

From [MySQLdiscussion group] 2023-09-12 12:44:28 0  1  700

SQL NOT IN subquery causes performance degradation

I want to use a table to check the streets. Query is not optimal Query is taking too long Can anyone help me S...

From [MySQLdiscussion group] 2023-09-12 12:21:35 0  2  621

The rewritten title is: How to match two attributes and get multiple results using SQL query?

Long story short, I'm working on an app that matches people who want to adopt a dog with available dogs in she...

From [MySQLdiscussion group] 2023-09-12 11:28:18 0  1  646

SQL query: Find the element with the highest frequency

I'm trying to write a SQL query to find the mode, i.e. the element that occurs more often than other elements....

From [MySQLdiscussion group] 2023-09-12 10:36:13 0  1  604

The rewritten title is: MySQL queries using Python

I'm new to Python and SQL. I'm trying to create a simple code to create and access a database and then create ...

From [MySQLdiscussion group] 2023-09-12 08:59:48 0  1  533

Why does TIMESTAMPDIFF always return null?

I want to notify users that the server is undergoing maintenance and provide them with the remaining time unti...

From [MySQLdiscussion group] 2023-09-11 23:45:20 0  1  693

I want to exclude records that do not fall within the value range specified in case when statement - SQL/MySQL

I'm trying to set a seasonal range for specific dates from the DTBL_SCHOOL_DATES table. Below is my logic that...

From [MySQLdiscussion group] 2023-09-11 23:15:24 0  2  596