I'm trying to make a live react control panel, so when you push a button on the web control panel the data (true or false) goes to the SQL database (phpmyadmin) and the when the data changes te SQL database…
I am trying to create a trigger to update the Project table whenever the Assign table is updated, yet I keep receiving this error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB…
I am unable to run mysql as admin. In the xampp command window, I tried login in as root it was successful but not able to run MySQL as admin. Even in the control panel, there are no such errors…
As I was following on this tutorial https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-with-nginx-on-an-ubuntu-18-04-server, halfway I entered a wrong option. That is why I aborted the installation proces, removed phpmyadmin with the commands below and tried to restart the installation. sudo apt-get remove phpmyadmin sudo apt-get…
I have been using WAMP for testing a web app including phpmyadmin to view my databases. I've made no changes whatsoever to my environment since the last time I was working and suddenly I am getting some sort of fatal…
I have two tables: products - which has UnitsSold(total/cumulative amount of sold products/item), and sales - which has SoldQuantity (how many units sold per transaction) The same unit could be sold many times, so we need to calculate how many…
I have created MySQL table in database. Table name is products and the columns are( prodict_id(pk) product_name and pack_size) as shown in the figure below. What I want to do is , copy all the rows in the table and…
I'm trying to import an online wordpress website on my local Wamp server. I exported my database from my online website, and now I'm importing it to my local server with phpmyadmin. Then, the following error message shows up :…
If I go on the welcome page of phphmyadmin there's no login form. After a double check, I notice the form is hidden: <form method="post" action="index.php" name="login_form" class="disableAjax login hide js-show" data-bitwarden-watching="1"> Any ideas about this? Some tech: Server version:…
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…