I want to see new records and updates entered in the log table, I created a trigger for this but I get error 1442. Can you help me, please? CREATE TRIGGER `trigger_changes` AFTER UPDATE ON `customers` FOR EACH ROW Update…
I use mysqldump command to dump the some information from the sql tables. To do this I read about mysqldump. Then for a test I made a direct command which will run able in the terminal shell. That command were…
I want to get all data of current date from my database I'm using phpMyAdmin this is the query which I use but it did not show any data SELECT * FROM tables WHERE time = CURDATE();
I have a simple database on my localhost and I am following a book I created tables in it but after I used shared file addresses i.e include ['SERVER_DOCUMENT'].'path of file' the access to PHPMyAdmin is denied. IT says that:…
I'm making a wordpres website. i try to get a value from mysql DB. Actually I managed to get a lot of value. but this one so complicate. For Example; there is a value in DB. its meta_key => 'th_room_price'…
I have a MySQL table which has a column called "created_at" which is a TIMESTAMP field. Whenever I try to insert datetime bigger than 2037 I get the following error: #1292 - Incorrect datetime value: '2039-06-18 16:54:35' for column 'created_at'…
PLEASE SEE THE LAST EDIT ON THE BOTTOM I have the following query using MySQL in phpMyAdmin: (SELECT id, name, rank1, rank2 FROM rank_list LEFT JOIN names ON names.id = rank_list.name_id WHERE type = "typeA" ORDER BY rank1 LIMIT 50)…
i tried to login to my phpmyadmin (EC2 instance) i tried to visit domain.com/phpmyadmin it didn't load then I typed domain.com/phpmyadmin/index.php it loads. After logging in I am seeing total mess of my phpmyadmin What could be the reason for…
When signing into to the app with username, the email is not used hence the following error is throw and vice versa "Notice: Undefined index: email in /Applications/XAMPP/xamppfiles/htdocs/menthor/login.php on line 16" I've tried putting the lines that were generating the…
I tried to implement a dependent drop down lists system. The code in contact.php page is: <?php $link = new mysqli("localhost", "root", "", "graphicdesign"); if($link->connect_error){ die("ERROR: Nu s-a putut realiza conexiunea la baza de date " .$link->connect_error); } $resultSet =…