Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
UPDATE
table1
SET
updatefield = newvalue
WHERE
products_id IN (
SELECT products_id
FROM table2
WHERE field1=value1)
(products_name LIKE '%3/4%' OR products_description LIKE '%3/4%') AND categories_id=283)
UPDATE
`db`.`products_to_categories`
SET
`categories_id`=267
WHERE
`categories_id`=283
AND
`products_id` IN (
SELECT `products_id`
FROM `products_description`
WHERE `products_name` LIKE '%3/4%');
UPDATE
products_to_categories
SET
categories_id=267
WHERE
products_id IN (
SELECT
product_id
FROM
(SELECT
products_id,
products_name
FROM
products_description d,
(SELECT
products_id
FROM
products_to_categories
WHERE
categories_id=283) c
WHERE
d.products_id O c.products_id)
WHERE
products_name LIKE '%3/4%')
//Block1:
SELECT
products_id
FROM
products_to_categories
WHERE
categories_id=283
//Block2:
SELECT
products_id,
products_name
FROM
products_description d,
([Block1]) c
WHERE
d.products_id O c.products_id
//Block3:
SELECT
product_id
FROM
([Block2])
WHERE
products_name LIKE '%3/4%')
Hallo,
ich habe jetzt:
PHP:UPDATE `db`.`products_to_categories` SET `categories_id`=267 WHERE `categories_id`=283 AND `products_id` IN ( SELECT `products_id` FROM `products_description` WHERE `products_name` LIKE '%3/4%');
Aber es geht nicht, mysql meldet zwar keinen Fehler, aber es wird das komplette mysql ausgelastet und bringt aber kein Ergebnis.