UNION cannot combine two results with the same column

Enter image description here I'm trying to combine these two queries in the same display result, but the Mysql...

From[MySQLdiscussion group]2024-04-03 00:23:39 0 1 387

Problem: MySQL regular expression (limiter not working)

Mod Note: Do Not Remove/Do Not Close I asked this question before and the admins closed it because they though...

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

New entries only: Update recently added fields

I'm trying to find a way to be able to update the unit code for any new unit product, but keep the original un...

From[MySQLdiscussion group]2024-04-02 22:48:20 0 1 381

How to search title and use another column to check uniqueness

I have some scraped product data in the database and I want to use it on my website. I want to write a query t...

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

A single SQL query that will use one SELECT result in the next subquery in the same request

I'm looking for a possibility to (re)use one SQL select result to get the values of different subselects wit...

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

Limit SQL query conditions based on a column

I have two tables, one is called user and the other is called payment. A user can have multiple payment record...

From[MySQLdiscussion group]2024-04-02 17:17:29 0 1 299

How to select, match and return values in mysql query?

I have two tables, the transfer table and the clubs table. This is the table transfer: id first name last name...

From[MySQLdiscussion group]2024-04-02 17:18:57 0 1 369

How can we pass SSL parameters to MySQL in Gramex's FormHandler?

I use this gramex.yaml configuration to connect to OTP's MySQL database: otp:url:'mysql+pymysql://$USER:$PASS@...

From[MySQLdiscussion group]2024-04-02 16:34:01 0 1 305

Maximum number of tickets served per hour per service - SQL

This is an answering service that has tickets from several different services and I would like to receive tick...

From[MySQLdiscussion group]2024-04-02 16:18:08 0 1 339

MySQL trigger statement fails on variable assignment

The following is the definition of the patient table: PatientstableColumns:PatientIdintAIPKFirstNamelongtextLa...

From[MySQLdiscussion group]2024-04-02 15:58:14 0 1 254

Get the latest row of data

table: task: id (bigint) name (varchar). Save task details job: id(varchar(UUID))task_id(bigint(class ID)),sta...

From[MySQLdiscussion group]2024-04-02 15:27:20 0 1 326

Retrieve the highest value in a column and its date

I have written code in MySQL to get the highest death value for various countries and their reporting date in ...

From[MySQLdiscussion group]2024-04-02 15:26:37 0 1 459

Display calculation results in SQL with 2 decimal places

I wrote a simple query to find the percentage of two columns, but I want the results to be in a column with on...

From[MySQLdiscussion group]2024-04-02 14:23:34 0 1 335

Looking for alternatives to shorten sqlcode

Please, I want to find another way example data date tomato phone book pen 2022-05-1522312022-05-153332 I saw ...

From[MySQLdiscussion group]2024-04-02 13:25:48 0 1 265

SQL - when lineid is '01', use newid, otherwise use id

I have such data in my table row number price €01100.0002200.000110.3401311.120114.330236.440389.700411.33 I w...

From[MySQLdiscussion group]2024-04-02 12:08:51 0 1 361