Debug School

rakesh kumar
rakesh kumar

Posted on • Updated on

How to update and Select row in phpmyadmin using sql command

Refer here

Requirement

Image description

Solution

Image description

UPDATE `users` SET `organisation` = 'organisation' WHERE `users`.`organisation` is NULL
Enter fullscreen mode Exit fullscreen mode
UPDATE `trips` SET `title` = 'Splendid Kashmir Tours' WHERE `trips`.`id` = 1;
Enter fullscreen mode Exit fullscreen mode
SELECT * FROM `trips` WHERE `trips`.`id` = 1;
Enter fullscreen mode Exit fullscreen mode

Image description

Top comments (0)