The number of daily active drivers has continued to increase since its inception

I have a list of drivers, orders and dates for the period January 1, 2022 to January 15, 2022 (15 days) in a t...

From [MySQLdiscussion group] 2024-03-30 22:52:01 0  2  396

How to save notifications for multiple users in phpmysql database without overloading the database with records

I'm concerned that I could easily create a crawl in the database while trying to ensure that all users in the ...

From [MySQLdiscussion group] 2024-03-30 22:51:20 0  1  517

Multiple starting letters for sorting countries

Now in my high school class we are learning about MySQL and how to select and sort items based on certain crit...

From [MySQLdiscussion group] 2024-03-30 22:35:22 0  2  504

SQL SUM of two column values ​​multiplied by date range

The question I need to answer is "What is the total cost of providing morphine to a patient named 'JohnSm...

From [MySQLdiscussion group] 2024-03-30 22:37:08 0  1  443

How to use the OR function for MySQL queries VB.NET

I have a problem with the last piece of code for my school project. I need to select multiple values ​​for a g...

From [MySQLdiscussion group] 2024-03-30 20:23:02 0  1  371

Best way to handle transactions efficiently using Promises

I'm creating a utility class for NodeJs to help me manage database transactions. My idea is to create a method...

From [MySQLdiscussion group] 2024-03-30 20:44:23 0  1  476

Limit grouping to 1 column when selecting multiple columns

I have a comment table comment_idwhen_added10 February 23, 2022 21 February 23, 2022 10 February 24, 2022 I ne...

From [MySQLdiscussion group] 2024-03-30 19:59:19 0  1  328

Indexing of dynamic search queries based on MySQL

This is my first project so I'm sorry I have a lot of questions. I'm trying to create an index to search the C...

From [MySQLdiscussion group] 2024-03-30 20:21:47 0  1  383

Mysql query returns too slowly

I have written a query. It works better. But currently, all tables have 100K rows, and one of my queries is re...

From [MySQLdiscussion group] 2024-03-30 18:25:44 0  1  470

Prisma room management system

I'm trying to create a database for a room management system but I'm confused about the relationships and can'...

From [MySQLdiscussion group] 2024-03-30 18:46:05 0  1  513

SQL syntax error encountered while trying GET REQUEST

Hi, I'm trying to display student data and their corresponding subjects based on subject_id foreign key and di...

From [MySQLdiscussion group] 2024-03-30 16:52:30 0  1  408

Find the maximum value in the table and then display the SQL groups separately and the number of maximum values ​​in each SQL group

IDPOSITIONEXPERIENCESALARY1top9015002bottom10015003top907504left9010005right10013006top9015007left8020008top80...

From [MySQLdiscussion group] 2024-03-30 15:53:50 0  2  429

SQL operation to copy rows from one table to another when index changes

Status Description I have two databases, DB1 and DB2, which have the same table Author with fields Author.ID a...

From [MySQLdiscussion group] 2024-03-30 14:52:06 0  1  381

Access JSON columns

How to access values ​​stored as JSON in status and date columns? Please see the example lines below. {"1...

From [MySQLdiscussion group] 2024-03-30 13:17:00 0  1  442

Node-Express MySQL API output JSON array as string

Try setting up an ExpressAPI server to get some data for a portfolio website. I have set up a MySQL table with...

From [MySQLdiscussion group] 2024-03-30 12:49:49 0  1  411