1

Topic: Simple request, in what an error?

wrote:

#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 oc_option_description JOIN colors ON oc_option_description. ` option_id ` = co ' at line 3

It is necessary to replace field values name in the table oc_option_description where option_id coincides with option_value_id from the table colors

UPDATE oc_option_description
SET ` name ` = oc_option_description. ` name`
FROM oc_option_description JOIN colors ON oc_option_description. ` option_id ` = colors. ` option_value_id`

2

Re: Simple request, in what an error?

nikki4;
Show admissible length, at you explicitly the request is cut stop short.
It is possible to check up in ini a file in section [mysqld].
SHOW VARIABLES LIKE ' max_allowed_packet ';

3

Re: Simple request, in what an error?

nikki4 wrote:

it is necessary to replace field values name in the table oc_option_description where option_id coincides with option_value_id from the table colors

UPDATE ` oc_option_description `, ` colors`
SET ` oc_option_description `. ` name ` = ' _'
WHERE ` oc_option_description `. ` option_id ` = ` colors `. ` option_value_id`

4

Re: Simple request, in what an error?

nikki4 , the citation of a fragment of request always begins with that byte where and there is a problem. As the most probable I consider presence of the unreadable character (we tell, a non-breaking space), but other variants are possible also.
The recommendation -  request anew, everything, it is strict without .

5

Re: Simple request, in what an error?

Release. Did not look at request type precisely.
Really, syntactic error. RTFM . There Should be something of type

UPDATE oc_option_description
JOIN colors ON oc_option_description. ` option_id ` = colors. ` option_value_id`
SET colors. ` name ` = oc_option_description. ` name`

And any FROM, here not Orakl.

6

Re: Simple request, in what an error?

Akina;
Thanks, gained!
Tried still a heap of everything, permanently errors. And your request worked!