Mysql returns different amount of rows – Phpmyadmin
If I run SELECT * FROM table; on one of my tables, I get 87709 rows. If I instead run SELECT * FROM table WHERE isDeleted = 0 OR isDeleted = 1; on the same table, I get 87686 rows.…
Update string with new string – Phpmyadmin
I want to update a table with a new url to replace the old one: UPDATE table1 SET column1 = REPLACE(column1, 'OLD URL', 'NEWURL') WHERE column LIKE '%OLDURL%' This updates it mostly but I only want to replace part of…
PhpMyAdmin is not able to load the table
I have a table where I have 1.5 million records (680 MB). When I am trying to open this table in PHPMyAdmin it is not able to load
Error when creating Index for table Mysql – Phpmyadmin
I'm working on create index for table with mysql. I've 2 tables: 1. account 2. x_activity (x is the account_id related to "account" table, EX: 1_activity, 2_activity). So i've created an "Index" for activity table: Here are my code: DROP…
connection to database works on localhost but not online – Phpmyadmin
My database works fine when it runs on my mac on localhost. But when I upload the code with filezilla online, the following warning occurs: "Warning: mysqli::__construct() [mysqli.construct]: (HY000/1045):Access denied for user 'root'@'localhost' (using password: YES) in /users/hassib/www/markme/index.php on line…
How to Search Records In MySQL Using StartTime(varchar) And EndTime(varchar)? – Phpmyadmin
Here I have some records, I want to search for records from 8:30 AM to 9:30 AM. I tried these query but not working: select * from table_name where '8:30 AM' BETWEEN start_time and end_time OR '9:30 AM' BETWEEN start_time…
PHP container can't connect to MySQL container – Apache
I'm trying to connect to containerized MySQL DB from PHP container although all the containers on the same network, the issue is I keep getting Connection failed: invalid data source name when I hit http://localhost:8080/dbTest.php although I've checked that the…
Connecting MySQL Server 8.0 using C# – Phpmyadmin
I'm trying to connect MySQL Server 8.0 running on windows to C#. Before this, I was using PhpMyAdmin but now I've installed MySql 8.0 Command Line Client and I want to connect my program with it. It is running on…
Mysql DISTINCT with more than one column (remove duplicates) – Phpmyadmin
My database is called: (training_session) I try to print out some information from my data, but I do not want to have any duplicates. I do get it somehow, may someone tell me what I do wrong? SELECT DISTINCT athlete_id…
Open php.ini in docker compose to add an extension – Phpmyadmin
I am using docker compose, I want to open few extensions and edit. So basically I want to open php.ini file. How can we exactly do that. However some solutions I read are saying to do changing in docker_compose.yaml, I…