NO ME DA:
te paso los campos de la tabla como son reales:
TABLA
categories
categories_id int(11)
category_head_title_tag varchar(80)
TABLA
categories_description
categories_id int(11)
categories_name varchar(32)
UPDATE `categories`
SET `categories.category_head_title_tag` = `categories_description.categories_name`
FROM `categories`
INNER JOIN `categories_description`
ON `categories.categories_id` = `categories_description.categories_id`
WHERE `categories.category_head_title_tag` <> `categories_description.categories_name`
Cita: MySQL ha dicho:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `categories`
INNER JOIN `categories_description`
ON