Convert mysql seconds to hours, minutes and seconds

sec_to_time does not work. The number of seconds entered is too large, so it will be displayed in the form of ...

From [MySQLdiscussion group] 2023-08-02 09:50:53 0  0  368

How to avoid grouping on specific columns

You can have data within appointments, and you can have multiple ranges of data per appointment point, when co...

From [MySQLdiscussion group] 2023-07-25 14:08:22 0  1  522

How to return the output of a pivot table in MySQL?

If I have a MySQL table like this: company_nameactionpagecount----------------------------------CompanyAPRINT3...

From [MySQLdiscussion group] 2023-07-25 13:59:22 0  2  566

MySQL: Sorting duplicate numbers ascendingly

I have a table that looks like this: id value 112131425262. I want to sort them in increasing order, in a circ...

From [MySQLdiscussion group] 2023-07-25 12:41:47 0  1  596

How to connect from localhost to docker container running in docker network

I created a container for mysql using dockercomposelikethis: version: "3.3" service: database server...

From [MySQLdiscussion group] 2023-07-25 11:54:51 0  1  578

MySQL uses another field for fuzzy query

I have a table with two string columns: Url and ModelId. I need to return those records whose URL contains Mod...

From [MySQLdiscussion group] 2023-07-25 11:34:12 0  2  544

Encountered a problem matching rows in the database.

I want to get the row count to check if the same email already exists in the database. I tried several methods...

From [MySQLdiscussion group] 2023-07-25 10:47:08 0  1  549

Optimize table indexes in MySQL

我有一个表(trackingsearches):CREATETABLE`searches`(`id`int(10)unsignedNOTNULLAUTO_INCREMENT,`deleted`tinyint(1)unsi...

From [MySQLdiscussion group] 2023-07-25 09:47:08 0  1  658

The search contains only results for the submitted search input value.

I have a search function that retrieves data about vehicles from a database using three types of search inputs...

From [MySQLdiscussion group] 2023-07-25 09:17:02 0  1  617

Find matching integers in JSON.

I want to find 123 in a JSON string in MySQL. This is my query: SELECT * FROM `reports` WHERE JSON_CONTAINS(js...

From [MySQLdiscussion group] 2023-07-25 08:47:02 0  1  561

GROUP_CONCAT using the CASE statement can produce multiple outputs.

I have a SQL query that contains the following line of code: GROUP_CONCAT(CASE WHEN t3.ship=1 AND t4.item=0 TH...

From [MySQLdiscussion group] 2023-07-25 08:17:06 0  1  663

Running MySQL in Docker and persisting data to my created directory [duplicate]

I'm trying to run MySQL in Docker and persist the data to a directory I created. I ran the following command: ...

From [MySQLdiscussion group] 2023-07-24 23:47:05 0  1  581

MySQL - How to convert columns to rows?

ID | a | b | c 1 | a1 | b1 | c1 2 | a2 | b2 | c2 How to reorganize behavior IDs, column headers and value...

From [MySQLdiscussion group] 2023-07-24 23:17:01 0  1  628

Find users who visit only one city instead of multiple cities in MySQL [duplicate]

I have a table with user ID, city and booking date. I need to find out which users visited only one city withi...

From [MySQLdiscussion group] 2023-07-24 22:47:07 0  1  632

Alembic - Using composite primary keys causes incorrect table definition in MySQL

I have multiple "versioned" database SQLAlchemy models that use composite primary keys, achieved by ...

From [MySQLdiscussion group] 2023-07-24 22:17:01 0  1  716