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…
Tables and data: CREATE TABLE major ( id INT PRIMARY KEY, name VARCHAR(200) ); insert into major values (101, 'Computing'), (102, 'Arquitecture'); CREATE TABLE student ( id INT PRIMARY KEY, name VARCHAR(200), major_id INT, foreign key(major_id) references major(id) ); insert…
We have a WordPress site that contains a Q&A plugin, that needs to be moved to a different hosting. The Q&A posts only make up for a fraction of the total Posts table, so I want to filter them out…
I'm trying to make a webshop using php, laravel, mysql and css. But when i try to make a migration table using foreign keys for products and orders i get this error: SQLSTATE[42000]: Syntax error or access violation: 1064 You…