MYSQL Synthax error with UPDATE

[tidou]

Hello everibody

I have a synthax problem with this query :

UPDATE FICHIER_DL
 SET id_sous_cat =   SELECT flash_cat.id AS id_sous_cat
 from flash_cat, flash 
WHERE flash_cat.nom = flash.cat;   

Mysql return me this error :

Erreur de syntaxe près de 'SELECT flash_cat.id AS id_sous_cat from flash_cat, flash WHERE f' à la ligne 1

Can someone correct my query please

Thanks in advance

PS I use MYSQL 4.0.15-max-debug

[LordShryku]

MySQL's support for subqueries has never been up to snuff, but the general rule is to use parens around the subquery.

UPDATE FICHIER_DL
   SET id_sous_cat = (SELECT flash_cat.id AS id_sous_cat
                        FROM flash_cat, flash 
                       WHERE flash_cat.nom = flash.cat);

You must also ensure your subquery is only returning one result, otherwise you'll get another error stating multiple values returned.

Good luck...

[tidou]

LordShryku>thanks but I have already try

UPDATE FICHIER_DL     SET id_sous_cat = (SELECT flash_cat.id AS id_sous_cat                          FROM flash_cat, flash                          WHERE flash_cat.nom = flash.cat);

It return me always synthax error.

I have recreate the table and use a sub query with a insert query so it works now.

Thanks
:rolleyes: