Grouping in REGEXP_SUBSTR() in MySQL 8.x

I'm trying to use a regular expression that I know about but it doesn't seem to work in MYSQLv8.0. I'm trying ...

From [MySQLdiscussion group] 2024-04-02 11:56:00 0  1  612

Disallow using same target table in update clause in MySQL

I have a table called "employee". The table creation code is as follows: createtableemployee(namevar...

From [MySQLdiscussion group] 2024-04-02 10:49:18 0  1  449

Create a MySQL function to return a value from a SELECT result

I want to create this function on mySql8. It will create a sequence number like 00001,00002CREATEFUNCTIONdbOne...

From [MySQLdiscussion group] 2024-04-02 10:33:22 0  1  536

freeswitch.Dbh causes freeswitch to shut down automatically

When I test freeswitchluaodbcmysql in docker, freeswitch automatically closes when executing freeswitch.Dbh(&q...

From [MySQLdiscussion group] 2024-04-02 08:47:55 0  1  657

Left join results in empty result

Am I using the correct connection method here? Trying to figure out where the problem is in the code. Try chan...

From [MySQLdiscussion group] 2024-04-02 00:27:45 0  1  510

Storing array as JSON in Codeigniter PHP not working properly in database

I'm trying to use the codeigniter website to store an array as json in a database like this: $this->db->...

From [MySQLdiscussion group] 2024-04-02 00:08:37 0  1  528

Flutter cannot get the new value of a variable when called in another class

I have this StatefulWidget which is supposed to retrieve data from MySQL database based on conditions and add ...

From [MySQLdiscussion group] 2024-04-01 22:37:38 0  1  573

How to write this SQL query using Yii Query Builder

I have this SQL query that is doing what I want: SELECT`Table1`.*FROM`Table1`LEFTJOIN`Table2`ON`Table1`.`idTab...

From [MySQLdiscussion group] 2024-04-01 21:29:26 0  1  561

One-to-many mapping Hibernate

I'm trying to keep 6 comments in the Comment table of the database using a foreign key to the post id, but the...

From [MySQLdiscussion group] 2024-04-01 19:57:24 0  2  595

How to keep the first X rows and delete table rows

I have a big table with millions of records in MySQLincident_archive, I want to sort the rows by created colum...

From [MySQLdiscussion group] 2024-04-01 18:32:54 0  1  614

Title: Unable to find Laravel 8 login page in Jetstream Inertia's AUTH package

I'm trying to design a Laravel8 login page but I found it in the button of the login page and I want to see it...

From [MySQLdiscussion group] 2024-04-01 16:53:48 0  1  514

How to delete pairs selected into own table

I have joined a table myself and I have the duplicate pairs highlighted in the image below, how can I remove t...

From [MySQLdiscussion group] 2024-04-01 16:39:46 0  2  508

Extract differences of consecutive values ​​in MySQL 5.7

Name Date Hour Count Mills 2022-07-172312 Mills 2022-07-180015 Mills 2022-07-180120 Mills 2022-07-180222 Mills...

From [MySQLdiscussion group] 2024-04-01 15:51:07 0  2  503

Can this where clause be optimized?

Can anyone help me solve this problem? I have a question about the following feature; can I create a virtual c...

From [MySQLdiscussion group] 2024-04-01 16:12:46 0  1  512

The length of varchar storage in mysql

Sorry, English is not my native language... :( I wanted to understand how the actual length of varchar is stor...

From [MySQLdiscussion group] 2024-04-01 15:50:34 0  1  425