the thing is, i have a table students table and another scores table and i already have all the students in the scores table but the class field is still empty so, i thought i could update all of them…
I have made 2 test databases to reflect my problem of trying to find what rows are missing in the old table in old database, that are present in the new table in new database. MariaDB [(none)]> SELECT * FROM…
I'm trying to log-in to MySQL server with PHPMyAdmin but it does not work, I insert true username and password but it still doesn't work and I don't know what's the reason error: mysql_real_connect(): (HY000/1045):Access denied for user 'root'@'localhost'(using password…
The table had a great large of data in one field (TEXT type). After some data was removed, the table is still the same size. A lot of data was removed that's why i'm sure that the table has to…
I use xampp to develope my Wordpress sites, 3 months ago I set up a project and accessed localhost/phpmyadmin with no issues and have been working on the project since. However yesterday I tried to set up a new project…
In my prestashop database I tried to update the default product attribute when there is 0 quantity for that one. I check if quantity is 0 and then set default_on to null. Then I try to set another attribute default_on…
i have 3 tables like this questions_table question_id | content | user | 1 | my first question | [email protected] | 2 | my second question | [email protected]| replies_table reply_id | question_id|user |content |voteCount| 1 | 1 |[email protected] |first reply…
When i try to create view like this CREATE VIEW data2tables AS SELECT * FROM Employees e INNER JOIN Computers c ON e.id = c.id WHERE e.name = 'Georgi' AND c.department = 'Sales' it gives me error saying that #1060…
I have a simple sessions table which looks like this: sid watchtime 1 01:07:00 2 01:07:00 3 01:34:00 4 01:36:00 5 01:36:00 6 01:59:00 7 01:59:00 8 00:00:00 9 00:00:00 10 03:42:00 11 00:16:00 12 00:49:00 13 00:55:00 14 00:00:00…
I have created a basic website that has a form. This form captures the following information from a user and stores it in the PHPMyAdmin table: First Name, Surname, Title, Description, Email Address, Display Email Address (Yes/No). An example of…