Laravel 10 IlluminateValidationValidator::validatePhone does not exist
I'm trying to make an Auth API with laravel 10. In the API I want a user to sign up with the email or phone number but when login in, I want to only use the phone number. So, I…
MySQL error when inserting data into JSON column ER_INVALID_JSON_CHARSET
Last Saturday I've upgraded our database into MySQL 8 since AWS is deprecating 5.7. Everything seemed to be working at first, but now we are seeing issues in our system. I'm using expressJS & sequelize with Node.js. The frontend is…
Mysql – Springboot spring data JPA using join and pagination
Java: 20.0 Springboot: 3.0.1 Table structure posts | CREATE TABLE `posts` ( `id` binary(16) NOT NULL, `posts` varchar(5000) DEFAULT NULL, `created_at` datetime(6) DEFAULT NULL, `updated_at` datetime(6) DEFAULT NULL, `user_id` binary(16) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK8omq0tc18jd43bu5tjh6jvra7taq` (`user_id`), CONSTRAINT `FK8omq0tc18jd43bu5tjh6jvra7taq`…
Mysql – Deleting rows found with left join on SQL
I am using this query to show all the departments and their managers, including the departemnts with no managers, that's why I am using left join. Now I need to delete the departements where there is no manager. This is…
Finding the names of columns with a common value in MySQL
I have a table named 'fiction' created in MySQL. The table looks like this fiction: id name gender image browser os 1 chris male 1 0 ios 2 emma female 1 1 ios 3 james male 0 0 android 4…
MySQL CASE with user parameter in WHERE clause
I am trying to obtain all days to a month in my MySQL database. This query is being called in one of my Grafana dashboards that has a variable for the year, the month and the day. This query is…
Mysql – How to make join force to use index?
I have a huge dataset on two tables (users, pos_transactions), and I need to execute a join on them. I wrote the query both with join and subquery approches. Both looks Non-optimal: explain SELECT pt.card_number FROM pos_transactions pt where user_id…
How to use WHERE NOT IN in DB:Raw Laravel
How to use WHERE NOT IN in DB:raw Laravel? Here's my sample code $query = DB::select(DB::raw("... WHERE ID NOT IN (:ids) ..", array( 'ids' => "1,2,3" ))); I also tried this $ids = "'1','2','3'"; $query = DB::select(DB::raw("... WHERE ID NOT…
MySQL subquery appears to be slowing down my main query, any tips on how to speed this up?
I have a simple subquery in MySQL which produces a set of codes, something like 'LPR','LFR','LFL' (more codes can be returned). Using this in my main query slows it right down, like it can take a minute or 2 to…
Mysql – In python when I click the submit button in my data entry app it displays the success message. But the database receives no entries in it
Form submitted No entry in the database The image attached describes the problem that I am facing. I can't find any problem in the code stated below. Is there any problem with the SQL connection? Kindly state what should I…