I want to pass a variable from one PHP file to another, for that, I am trying to use ajax. Now, in my 'index.php' file, I have a button. When that button is clicked, I want to pass that button's…
after starting the the mysql server within docker, it stops immediately. the docker log is not very meaningful ;) i've no idea, what's wrong. in my opinion i didn't changed anything. mysql 15:04:45.27 mysql 15:04:45.29 Welcome to the Bitnami mysql…
SELECT * FROM time_on_screen where id='2' AND where date between '2020-10-04' and '2020-10-10'
I have 2 tables, 1 with ~1.5 million records and other with ~200.000, and i need to delete duplicates in the big table. I have one query and i think its correct, however can´t finish process because needs very much…
Hello everyone, 1/ I want to do a sql query that transform the result from row to column like it's shown in the picture. Is it possible ? 2/ How can I update the second table with the first one…
i am using a mysql database version 5. I have a table, that has about 500.000.000 rows.The table reclaims 50GB of diskspace if i trust phpmyadmin. I like to delete 90% of the rows to reclaim disk space. What is…
We have automation to login into different websites and perform some operations on website accounts. It is required that only one BOT can login simultaneously into a specific account to avoid inconsistency in automation flow. We have a table in…
I accidentally removed the user you set up when installing mysql (Using DROP USER), I was assuming that if I created another 'root'@'localhost' user I would get the permissions back aswell. but it was not the case after I created…
So I've seen this question asked many times but I have not found an answer to my issue. I'm using phpmyadmin, I have 1 table with 2 columns and I have a .csv with 2 columns. My csv does not…
After installing Docker and Laradock on my Mac I'm trying to start the docker containers using the command: docker-compose up -d nginx mysql phpmyadmin I get the output: Starting laradock_mysql_1 ... done Starting laradock_docker-in-docker_1 ... done Starting laradock_phpmyadmin_1 ... done…