How to update and Select row in phpmyadmin using sql command

UPDATE `users` SET `organisation` = 'organisation' WHERE `users`.`organisation` is NULL

UPDATE `trips` SET `title` = 'Splendid Kashmir Tours' WHERE `trips`.`id` = 1;

SELECT * FROM `trips` WHERE `trips`.`id` = 1;

UPDATE `bookings` c
JOIN `addvechicles` o ON c.`vechicle_id`= o.`id`
SET c.`myvechical_id` = o.`vehical_id`
WHERE c.`myvechical_id` IS NULL;

UPDATE "Command" c
SET category_id = o.id
FROM "Category" o
WHERE c.category_id IS NULL
AND c.category = o.category;  -- Match category name between the two tables

INSERT INTO newshop (id, vender_ID, partner_name, location, city, gst_number, number)
SELECT 
    NULL,  -- This allows AUTO_INCREMENT to work
    u.id AS vender_ID,
    CONCAT('Shop_', ROW_NUMBER() OVER (ORDER BY u.id), '_User', u.id) AS partner_name,
    CONCAT('Location_', ROW_NUMBER() OVER (ORDER BY u.id)) AS location,
    c.city_name AS city,  -- Assigning a unique city
    CONCAT('GST', ROW_NUMBER() OVER (ORDER BY u.id), u.id) AS gst_number,
    CONCAT('Contact_', ROW_NUMBER() OVER (ORDER BY u.id)) AS number
FROM users u
JOIN (
    SELECT city_name, ROW_NUMBER() OVER (ORDER BY city_name) AS rownum
    FROM cities
    WHERE country_id = 101
    LIMIT 3844
) AS c 
ON c.rownum <= 3844
LIMIT 3844;

INSERT INTO addvehicles (vender_ID, shop_id, vehical_id, vehicale)
SELECT 
    u.id AS vender_ID,
    s.id AS shop_id,
    v.id AS vehical_id,
    v.vehical AS vehicale
FROM (
    SELECT id FROM users ORDER BY RAND() LIMIT 3843
) AS u
JOIN (
    SELECT id FROM shops ORDER BY RAND() LIMIT 3843
) AS s
JOIN (
    SELECT id, vehical FROM addvehical_byadmins WHERE vehical = 'car' ORDER BY RAND() LIMIT 11529
) AS v
ON 1=1
UNION ALL
SELECT 
    u.id AS vender_ID,
    s.id AS shop_id,
    v.id AS vehical_id,
    v.vehical AS vehicale
FROM (
    SELECT id FROM users ORDER BY RAND() LIMIT 3843
) AS u
JOIN (
    SELECT id FROM shops ORDER BY RAND() LIMIT 3843
) AS s
JOIN (
    SELECT id, vehical FROM addvehical_byadmins WHERE vehical = 'bike' ORDER BY RAND() LIMIT 11529
) AS v
ON 1=1;

UPDATE shops s
JOIN (
    SELECT city_name, ROW_NUMBER() OVER () AS rn
    FROM cities
    WHERE country_id = 101
) c
ON s.id = c.rn
SET s.city = c.city_name;

INSERT INTO africa_states (
    id, state_name, country_id, country_code, fips_code, iso2, 
    created_at, updated_at, flag, wikiDataId
)
SELECT 
    s.id, s.state_name, c.id AS country_id, c.country_code, c.dial_code, c.iso3 AS iso2,
    s.created_at, s.updated_at, c.flag, c.wikiDataId
FROM states s
JOIN countries c ON s.country_id = c.id
WHERE c.id IN (5, 7, 24, 28, 35, 36, ...);

INSERT INTO asia_cities (
    city_name, state_id, country_id, country_code, latitude, longitude, 
    created_at, updated_on, flag, wikiDataId
)
SELECT 
    c.city_name, s.id AS state_id, co.id AS country_id, co.country_code, 
    c.latitude, c.longitude, c.created_at, c.updated_on, co.flag, co.wikiDataId
FROM cities c
JOIN states s ON c.state_id = s.id
JOIN countries co ON s.country_id = co.id
WHERE co.id IN (12, 16, 18, 19, ...);

SELECT 
    ec.id,
    ec.errorcategory,
    ec.api_section,
    et.error_type_name
FROM
    public."Error_category" ec
JOIN 
    public."ErrorType" et
ON 
    ec.error_type = et.id
ORDER BY 
    ec.id ASC;