Laravel Eloquent uses strings for WHEREIN operations

I have a string inside $loc_name1='Cochin','Haydaraba','Bhuvaneswar'; I have a Laravel query $employees=DB::ta...

From [MySQLdiscussion group] 2024-03-27 18:41:43 0  1  454

Windows MAMP PHP encountered fatal error: Uncaught PDOException: Driver not found. The PHP.ini file has correctly uncommented sections

I have the following error - FatalError:UncaughtPDOException:couldnotfinddriver when trying to connect via PDO...

From [MySQLdiscussion group] 2024-03-27 16:18:23 0  1  443

When does the mysql performance mode event "wait/synch/cond/sql/MYSQL_BIN_LOG::COND_done" trigger?

I'm using AuroraMysql5.7.mysql_aurora.2.07.2 and I'm facing a bottleneck in a load test that writes a large wo...

From [MySQLdiscussion group] 2024-03-27 15:58:10 0  2  561

GoLang method to load nested objects using GORM

Hi, let's say I have 3 structures in the following format typeEmployeestruct{IdintNamestringCompanyIdint`gorm:...

From [MySQLdiscussion group] 2024-03-27 13:20:01 0  2  496

mysql async/await in Node.js just returns undefined

I've been trying to solve this problem for two days now and have looked through basically everything I can fin...

From [MySQLdiscussion group] 2024-03-27 12:32:47 0  2  413

LIMIT error when executing query

This is the query I am trying to write selectposts.*,users.*FROMpostsINNERJOINusersONposts.user_id=users.idWHE...

From [MySQLdiscussion group] 2024-03-27 12:26:04 0  1  395

Speed ​​up Mysql queries during batch updates

I need to update records like updatetableabcsetmarks='15'whererollno='432423'andpcode='ABC234'; for nearly 10,...

From [MySQLdiscussion group] 2024-03-27 11:41:12 0  1  421

Compare Mysql's WHERE condition using JSON_TABLE value

I am getting a list of IDs in the form of a comma separated list of JSON values, some sample datasets are as f...

From [MySQLdiscussion group] 2024-03-27 11:34:54 0  1  397

Trait binding 'FieldAttr:ToTokens' not satisfied: error

I want to deploy a Dockerfile version on EC2 (fargate). I'm getting the following error in cloudwatch. "F...

From [MySQLdiscussion group] 2024-03-27 09:30:39 0  2  350

Get the current user in MySQL Get the current user's MySQL username, no hostname required

I know that we can use user() and current_user() functions to get the currently logged in user. But I only nee...

From [MySQLdiscussion group] 2024-03-27 08:31:44 0  1  340

How to add a column of type array using phpMyAdmin or sql

How to add column of type array using phpMyAdmin know change table name add column listid integer array; chang...

From [MySQLdiscussion group] 2024-03-27 00:18:52 0  1  479

Liquibase and MySql - How to automatically generate id from UUID

I want to create a script for liquibase. When I do an insert in the next script, I want to automatically gener...

From [MySQLdiscussion group] 2024-03-27 00:01:32 0  1  506

How to send multiple requests using axios?

I'm making a react registry with some fields (idStudent (primary key and auto-increment), first name, last nam...

From [MySQLdiscussion group] 2024-03-26 21:18:41 0  1  364

Initializing a container to run on MySQL using Kubernetes

I'm running mysql as an init container of a kubernetes deployment. For various reasons I need to start mysql i...

From [MySQLdiscussion group] 2024-03-26 19:48:31 0  1  400

How to merge multiple rows into single row based on column in MySQL or Hive

I need to generate the average sales for each title between 2019 and 2021. There are 2 input tables: TitleTabl...

From [MySQLdiscussion group] 2024-03-26 19:11:12 0  1  325