I'm trying to execute this query directly in mySql but it's not working

```
UPDATE article a
SET a.qte_art = (a.qte_art+(i.qte*1))
FROM(
        SELECT l.qte, l.article_id_article
        FROM ligne_sortie l, bon_sortie b, article a
        WHERE l.bon_sortie_id_sortie = b.id_bsr 
        AND l.article_id_article = a.id_article
        AND b.id_bsr = 1 

    ) i
WHERE a.id_article = i.article_id_article

```

> 
> #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(SELECT l.qte, l.article\_id\_article
>  FROM ligne\_sortie l, bon' at line 3 
> 
> 
>