MySql/MariaDB: Using indexes "directly" in queries?

I'm wondering if it's possible with MySql/MariaDB to use indexes directly in queries. Suppose we have a simple...

From [MySQLdiscussion group] 2023-09-15 14:40:21 0  1  616

Is there any way to get the correct conditions? Both options in MYSQL fail to achieve expected results

SELECTcstmr_typeFROMadd_vehicleWHEREcstmr_type='Visitor'ANDcstmr_type='Hospital';SELECTcstmr_typeFROMadd_vehic...

From [MySQLdiscussion group] 2023-09-15 13:36:02 0  1  560

A guide to migrating a Drupal 9 database to a personal MySQL database

When I use a tool like PHPMyAdmin on my own server, the data currently being used with Drupal is of course enc...

From [MySQLdiscussion group] 2023-09-15 10:54:14 0  1  593

How to display output in % using this case condition in clickhouse database

How can I use this case condition in clickhouse database to display the output in % form. ROUND(count(distinct...

From [MySQLdiscussion group] 2023-09-15 00:07:20 0  1  714

How to get related rows between two tables

My Forms: Form 1 Exercise|primaryMuscleGroup|motionName||------------------|------------------ --||chest|paral...

From [MySQLdiscussion group] 2023-09-14 23:53:48 0  2  612

Unable to load python dataframe into mysql

I'm trying to load a python dataframe into mysql. It returns the error "Failed to process format paramete...

From [MySQLdiscussion group] 2023-09-14 22:10:45 0  1  588

Error while inserting multiple inputs in sql

This is the query I use constdbQuery=INSERTINTO tasks(activity, type, participants, price, link, key, accessib...

From [MySQLdiscussion group] 2023-09-14 21:56:33 0  1  537

MySql and SQL settings before update trigger Updates of different tables/columns cannot update tables in stored functions/triggers

I have a join table with 2 tables (A and C) with n:m relationship. The connection table (B) also holds some in...

From [MySQLdiscussion group] 2023-09-14 21:54:36 0  1  582

Optimize your use of interval functions

I have to do the following: rank users with persona='z' in order from highest to lowest in the last week. I wr...

From [MySQLdiscussion group] 2023-09-14 16:24:44 0  1  627

Simple SQL query: sum the values ​​of the same column in one go

I have created this query: SELECTtable1.id,b.sumFROMtable1CROSSJOIN(SELECTSUM(id)sumFROMtable1)bORDERBYidDESC;...

From [MySQLdiscussion group] 2023-09-14 16:21:56 0  1  614

MYSQL group by last value but conditionally

I will explain my situation. MySQL5.7 I have 2 tables: registry and mobile. Both tables have IDMovement in com...

From [MySQLdiscussion group] 2023-09-14 15:37:56 0  1  439

How to ensure the data is correct if two DMLs occur simultaneously in Django ORM?

My Django project uses mysql and InnoDB engine. I have a table as shown below, the queue field default value i...

From [MySQLdiscussion group] 2023-09-14 15:11:12 0  1  557

How to filter out rows whose last login time is in the past 3 days or longer

I'm trying to write a feature for my service, but I'm having some difficulty getting it to work. Basically, I ...

From [MySQLdiscussion group] 2023-09-14 14:29:17 0  1  583

How to add existing schema to mysql on windows

I haven't seen anything about this topic anywhere, not even here. The problem is that I have a MySQL8.0 databa...

From [MySQLdiscussion group] 2023-09-14 13:51:44 0  1  604

Automatically add logged in user's ID to KeystoneJS foreign key field

I'm creating an application using the documentation provided by the KeystoneJS framework. So, in my applicatio...

From [MySQLdiscussion group] 2023-09-14 12:23:19 0  1  680