My project https://simbiat.ru/fftracker has a table, that is a junction table containing IDs of achievements earned by each character ID. It works fine, but my concerns is its size: before optimization it was 6.1 GBs and after it - 4…
I start on Xammp Apache and MySQL but when I click on admin instead of opening the phpmyadmin page I see this writing: Composer detected issues in your platform: Your Composer dependencies require the following PHP extensions to be installed:…
I have an HTML form, and I need to past data from it to mysql database in phpMyAdmin. I'm far from php and I don't know what to do with these errors, also I was unable to set up server…
Here is an image of my current code This is what my current code outputs when I enter it This is what I need my code to be outputting
My current code is to try to find 2 words "Red Table" in Title: SELECT `id`,`title`,`colors`, `child_value`, `vendor`,`price`, `image1`,`shipping` FROM `databasename`.`the_table` WHERE `display` = '1' and (`title` REGEXP '([[:blank:][:punct:]]|^)RED([[:blank:][:punct:]]|$)') and (`title` REGEXP '([[:blank:][:punct:]]|^)TABLE([[:blank:][:punct:]]|$)') The problem is, this is so slow!…
I got Laravel SQLSTATE[HY000] [1049] Unknown database Error, when I try to migrate using php artisan migrate:install/ migrate. I have properly named database on my localhost SQL server. I'm using XAMPP to run it. here's my .env: DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3307…
Good evening, I am currently working on the implementation of a shopping cart through PHP and MySQL, I am getting the following error at line 172 onwards, I have been looking at the quotes but I cannot find the problem,…
I have installed Ubuntu 18.04.3 LTS on my virtual box: I have also created an ssh tunnel the following way to connect to my remote db: admin@admin-VirtualBox:~$ ssh -v -v -v [email protected] -CNL 13306:localhost:3306 OpenSSH_7.6p1 Ubuntu-4ubuntu0.3, OpenSSL 1.0.2n 7 Dec…
"mytest_people" and "mytest_hobbies": PK FK <--- PK +----+------+------+------+ +----+-----------------+ | Id | Name | Age | H_ID | | Id | Hobby | +----+------+------+------+ +----+-----------------+ | 0 | Pete | 100 | 0 | | 0 | Reading News |…
I see this error in phpmyadmin: The number of joins that do not use indexes but I never use join in my code. Now I want get a list of query that do not use indexes. How can I get…