How to get the first two entries of each day of the week in MySql 5.5.34

I have a MySQL table with TENANT_NAME, MAX_CALLS and TIME_STAMP columns and no primary key, as per the require...

From [MySQLdiscussion group] 2023-09-03 23:31:06 0  1  533

Unable to create/set up connection: Unknown system variable 'query_cache_size'

I'm running an application using JDBC and MySQL, using hikari pool, but it cannot build due to the following e...

From [MySQLdiscussion group] 2023-09-03 23:32:54 0  1  629

How to stop background process from running shell script

I'm trying to run mysqld in the background to execute some commands using the mysql client, but when I switch ...

From [MySQLdiscussion group] 2023-09-03 18:16:08 0  1  713

The rewritten title is: MySQL query statements suitable for data cleaning

I have three tables. One table is the travel distance table createtableroutes(slatint,slngint,dlatint,dlngint,...

From [MySQLdiscussion group] 2023-09-03 18:23:21 0  1  579

Rewrite the title to: By getting the id of the ResultSet and returning it as a java.sql.Array

我有以下内容：defgetIds(name:String):java.sql.Array={valids:Array[Integer]=Array()valps:PreparedStatement=connection....

From [MySQLdiscussion group] 2023-09-03 18:10:50 0  1  500

Regardless of row, is the only column

Is there a way to make the entire row unique regardless of the value in the column? So, if there is a 1 in col...

From [MySQLdiscussion group] 2023-09-03 17:26:33 0  2  497

Why does this query update fail to execute successfully?

I have 2 tables, customers (3000 rows) and phone_call_log (350,000 rows). I need to implement the time of the ...

From [MySQLdiscussion group] 2023-09-03 16:39:14 0  2  557

How to add new value to "auth()" function after login?

I'm developing a project using Laravel8. There are some fields in my Users table, such as "us_name",...

From [MySQLdiscussion group] 2023-09-03 13:18:05 0  1  388

Syntax error or access violation - Laravel

I'm trying to select data from a database and unfortunately I'm getting the following error: 'Syntax error or ...

From [MySQLdiscussion group] 2023-09-03 13:10:32 0  1  543

mysql calculation to get profit or loss from 2 tables (purchases and sales) in first in first out mode

How to calculate profit or loss from these two tables? createtableitems(idintprimarykeyauto_increment,namevarc...

From [MySQLdiscussion group] 2023-09-03 11:46:30 0  1  2691

Unable to set MySQL's BOOL variable to a JSON's BOOL value?

MySQL version: 8.0.27 This makes no sense to me. I have the following definition: DECLAREp_array_onlyboolDEFAU...

From [MySQLdiscussion group] 2023-09-03 10:57:44 0  1  480

Restriction Java Spring Boot only accepts unique month-year combinations

How to allow input of only month-year combinations in JavaSpringBoot. I need to ensure that the user (Postman ...

From [MySQLdiscussion group] 2023-09-03 10:11:31 0  1  499

How to keep a user session active even after closing the browser or returning after being idle in PHP for a while?

In my code I can select "Remember me", when selected it saves the value of email and password in coo...

From [MySQLdiscussion group] 2023-09-03 08:53:53 0  1  479

How can I reduce these Prisma queries to a single query?

I need to udpate a user's last post by date without knowing the id beforehand, I can do it with two queries li...

From [MySQLdiscussion group] 2023-09-03 08:34:00 0  1  455

Filter Laravel users to show only uploaded users

I want to ask, how can I upload a file to the network on user 1, but only attach it to user 1, while currently...

From [MySQLdiscussion group] 2023-09-03 00:26:34 0  1  758