first time posting here. I am facing a problem with unpredicted behavior on my PROD server and my local environment. Here is some background on the situation: In my application (backend Laravel 7, frontend regular html/javascript) I need to search…
Hey guys i have 3 tables. First table called parceles(fid, REFCAT) Second table called informacio(fid, Ref_cadastral, fid_parceles) Third table called cedules(fid, Ref_cadastral, fid_parceles) fid_parceles is the foreing key from parceles in the two tables. I use this select for show…
I am trying to insert rows into a db table through a stored procedure. My table contains more than 500000 rows so when I execute the procedure, it takes more than 4h executing. Knowing that I am using Xampp server,…
I have two tables: The first one having the columns: |Name | Company | Job| with values such as (jack apple developer), (Julian google developer), (Jim eBay developer), (jack apple janitor), (Julian google janitor), (Jim eBay janitor), (jack apple manager),…
I have to join two tables in PHPMyAdmin. One is called tracks, the other one is album I select from album: album_name, year, album_number. Both tables have track_id column. I use that code: SELECT `album_name`,`year`, `album_number` FROM `album` JOIN `tracks`…
I'm working on a new docker-compose setup for Magento 2.4.2-p1. I started to have issues with MySQL container running out of disk space. There is a ton of space on my hard drive and on the Ubuntu (WSL2 on Windows…
My Xampp server is showing "MySQL shutdown unexpectedly". I did follow some solution to this problem but still it doesn't fix. All I have to do is every time I have to use MYSQL I uninstall and reinstall Xampp and…
I'm using this version of MySQL Ver 15.1 Distrib 10.5.4-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 and here is my server cpu info: cat /proc/cpuinfo I have 2 tables. Office and Customer. I have 1 row in my Office table…
I want to use MongoDB GridFS via PHP. I am creating a connection following. $m = new MongoDBDriverManager("mongodb://127.0.0.1:27017") This code works in a simple insert. How I can use GridFS? The PHP driver needs to change or the existing PHP…
I have been searching for hours and I do not understand MySQL so I am wondering if it is possible to do this another way. I have a custom html payment form that submits invoice number, amount, and name to…