We see large gaps in primary key column with auto_increment in mysql 8.0.31 release version in multiple tables (with default - innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)). Also I understand some smaller gaps can happen in this mode. We have…
I am trying to update one table based on another in the most efficient way. Here is the table DDL of what I am trying to update Table1 CREATE TABLE `customersPrimary` ( `id` int NOT NULL AUTO_INCREMENT, `groupID` int NOT…
I need to get the latest row of each combinations of sender_id & receiver_id my messaging table: CREATE TABLE messaging ( msg_id SERIAL, sender_id BIGINT NOT NULL , receiver_id varchar(255) NOT NULL , msg text default NULL, media_link TEXT DEFAULT…
My salary table looks like this, employeeId Salary salaryEffectiveFrom 19966 10000.00 2022-07-01 19966 20000.00 2022-07-15 My role/grades table looks like this, employeeId grade roleEffectiveFrom 19966 grade 3 2022-07-01 19966 grade 2 2022-07-10 I am trying to get the salary a…
I'm using regex word boundary b, and I'm trying to match a word in the following sentence but the result is not what I need. Connector Punctuations (such as underscore) are not being considered as a word boundary Sentence: ab﹎cd_de_gf|ij|kl|mn|op_…
I'm using MySQL 8.0 CE. I have an attribute where I want to store a TRUE or FALSE status and I want it to use as little space as possible. After reading the answers in this question: MySQL: Smallest datatype…
I installed mysql-community-server-8.0.13-1.el7.x86_64 on Centos 7 with Nginx, and added the phpMyAdmin to manage the databases but I keep getting error Cannot log in to the MySQL server from phpMyAdmin. I've tried the following and have been struggling for a…