"SQL query for valid records within a specific date range"

I am working on attendance control. Check-in and check-out are two different records in the table. It is possi...

From [MySQLdiscussion group] 2023-08-31 13:58:14 0  2  609

Unable to connect to mysql on GCP Compute Engine

I have installed mysql on a virtual machine in gcp using the following command: https://cloud.google.com/archi...

From [MySQLdiscussion group] 2023-08-31 10:58:27 0  1  620

How to handle multi-select drop-down forms for each row when implementing dynamic form saving in Laravel

In my form, I have a dynamic table with multi-select dropdowns color_id[] and size_id[] with the same name in ...

From [MySQLdiscussion group] 2023-08-31 10:43:09 0  1  546

Method to display database data: use console.log(req)

I ran console.log(req); to see the contents and found that the data from the database was displayed along with...

From [MySQLdiscussion group] 2023-08-31 08:47:42 0  2  488

MariaDB: Issues with SQL delete using exist clause

I run this select in MariaDB and it works as expected, it's just a select with exists: select*frompred_loan_de...

From [MySQLdiscussion group] 2023-08-30 23:16:01 0  1  445

How to use sum function to filter window functions in MYSQL

How can I write this query to filter out only results whose sum is greater than 50? I can't get it to work usi...

From [MySQLdiscussion group] 2023-08-30 22:03:52 0  2  584

How to call a program recursively when deadlock occurs?

My job "stored procedure" runs overnight. Every now and then I get stuck. I want to write a code tha...

From [MySQLdiscussion group] 2023-08-30 22:10:39 0  1  520

If group_concat does not return a value, is there any solution?

I wrote a query to convert several rows into columns based on a condition. However, there are cases where no r...

From [MySQLdiscussion group] 2023-08-30 19:44:24 0  2  596

Use SQL query to check if an entry contains a list of values ​​and compare

I have two MySql tables Courses(CNO:CHAR(10),CName:VARCHAR(50),DeptId:CHAR(3)) with the following schema: Each...

From [MySQLdiscussion group] 2023-08-30 17:47:36 0  1  531

Map sequence of numbers to corresponding letters

I have an int column containing values ​​no greater than 20. I want to select the uppercase letter it correspo...

From [MySQLdiscussion group] 2023-08-30 16:24:23 0  2  509

Hourly counting based on start time and end time data

In the table the data is in timestamp format but I am sharing it in time(start_at) and time(end_at) format. Ta...

From [MySQLdiscussion group] 2023-08-30 15:53:41 0  1  459

Connect to MySQL/MariaDB from command line client using URI connection string?

Given a database connection string of the URI style: mysql://<user>:<pass>@<host>:<port&g...

From [MySQLdiscussion group] 2023-08-30 14:30:55 0  1  544

Laravel Eloquent sort by date and also save entries by ranked index

I'm building a project using Laravel and I have a table with all my products. On this table, products are adde...

From [MySQLdiscussion group] 2023-08-30 14:46:23 0  2  458

Running docker-compose with MySQL in SpringBoot: Database not connected to Spring application

I have a microservice (product service) in SpringBoot and a database in MySQL and want to run my application i...

From [MySQLdiscussion group] 2023-08-30 12:33:00 0  1  573

Strapi cannot install MySQL on Windows localhost

I'm trying to install Strapi on my Windows 10 machine. I installed Apache and MySQL using XAMPP and verified t...

From [MySQLdiscussion group] 2023-08-30 09:37:02 0  1  602