Method to prevent two NOW() columns from being updated at the same time when updating NOW() of one column

I have a table that requires two different current times. First, I have an insert procedure that inserts actio...

From [MySQLdiscussion group] 2024-04-04 21:34:34 0  1  290

Convert SQL query to display output in time format

This is the data I'm using in my SQL database: Symbol|High_TimeAAPL10:01:00.000TSLA09:45:00.000AAPl10:05:00.00...

From [MySQLdiscussion group] 2024-04-04 21:02:02 0  1  239

I need to have employees with same joining month and year

CREATETABLE`staff`(`StaffID`intNOTNULLAUTO_INCREMENT,`Surname`varchar(40)DEFAULTNULL,`Given`varchar(40)DEFAULT...

From [MySQLdiscussion group] 2024-04-04 20:28:20 0  2  328

I'm trying to compare values ​​in two columns in two different tables

I have two tables, tableA and tableB. Table A has 4 columns, while Table B has 3 columns. The last column of t...

From [MySQLdiscussion group] 2024-04-04 20:05:03 0  1  262

Python/MySQL cannot persist integer data correctly

No code is required here. I want to save a very long number because I'm making a game and need to save scores....

From [MySQLdiscussion group] 2024-04-04 19:09:44 0  1  342

json added to MySQL

How to add new element to json variable in mySQL from this: value=['123'] do this: value=['123','456']

From [MySQLdiscussion group] 2024-04-04 19:17:30 0  1  329

MySQL: Find columns matching integers in a text (CSV) column

This table has a text column that stores references to other records in CSV format, for example: +----+-------...

From [MySQLdiscussion group] 2024-04-04 18:03:46 0  1  264

MySQL operation to get maximum sum function

I'm trying to set the maximum quantity to "max" and I'm getting the error: Error code: 1111. Invalid...

From [MySQLdiscussion group] 2024-04-04 17:49:26 0  1  347

Retrieve nested related values ​​in mysql

I'm trying to retrieve related values ​​based on multiple entries in a database. I'm very new to MySQL when it...

From [MySQLdiscussion group] 2024-04-04 17:29:06 0  2  336

Solve the error that mysql result contains multiple lines

When I execute this query I get this error message "Error code: 1172. The result contains more than one r...

From [MySQLdiscussion group] 2024-04-04 16:42:59 0  1  286

If the value exists, get the record sum and treat it as 1 instead of the exact value

I need to "open" as 2 and click as 1 but now I'm getting like open as 5 and click as 2"SELECTCO...

From [MySQLdiscussion group] 2024-04-04 16:49:24 0  1  323

Authserver "Unable to connect" "Host xxxxx is not authorized" after changing the LAN installation IP

Use the default Windows installation instructions on a bare metal Windows 10 installation. I got the server ru...

From [MySQLdiscussion group] 2024-04-04 15:06:41 0  1  346

Ways to find average time to state transition: using Eloquent or DB query

I have a table called state_histories with the following content: entity type entity_id state creation time in...

From [MySQLdiscussion group] 2024-04-04 14:58:46 0  1  327

Steps to remove a foreign key entry

I have two tables Employee and Address. Employee is my main table and Address is a subtable related to Employe...

From [MySQLdiscussion group] 2024-04-04 14:15:44 0  1  330

MySQL issues when summarizing sales data from two separate tables

Thank you very much in advance for your support. I'm learning SQL and generating some data to play with, but I...

From [MySQLdiscussion group] 2024-04-04 14:22:13 0  2  320