use sql SELECT nodejs

Question

I tried to use the select sql option in node js sql plugins. But I get a error with this syntax :

con.query( 'SELECT token FROM utilisateursinvitation WHERE nomwork = ?  AND 
Rejoint = ?  EXCEPT   SELECT token FROM utilisateursinvitation WHERE nomwork 
= ?  AND Rejoint = ? AND nomdugroupe = ?  ', 
[nomwork,tatazueyzyu,"nomdugroupe"], function (error, results, fields) {

and the error :

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXCEPT SELECT token FROM utilisateursinvitation WHERE nomwork = 'nomdugroupe' ' at line 1

Because I don't know the correct syntax. Can you help me ? THanks!

Possible duplicate of Error when using except in a query

CannedMoose
– CannedMoose

2018-04-17 10:21:43 +00:00
Commented Apr 17, 2018 at 10:21 — CannedMoose
– CannedMoose, Commented Apr 17, 2018 at 10:21

Gordon Linoff · Accepted Answer · 2018-04-17 10:27:16Z

1

EXCEPT is not MySQL syntax.

Instead, you can use NOT IN or NOT EXISTS:

SELECT ui.token
FROM ui.utilisateursinvitation ui
WHERE ui.nomwork = ?  AND ui.Rejoint = ?  AND
      NOT EXISTS (SELECT 
                  FROM utilisateursinvitation ui2
                  WHERE ui2.token = ui.token AND
                        ui2.nomwork = ?  AND ui2.Rejoint = ? AND
                        nomdugroupe = ?  
                 );

Or, if you are trying to fine tokens that have nomwork and Rejoint as the input values, but not a particular nomdugroupe:

SELECT ui.token
FROM ui.utilisateursinvitation ui
WHERE ui.nomwork = ?  AND ui.Rejoint = ?  
GROUP BY ui.token
HAVING SUM(nomdugroupe = ?) > 0;

answered Apr 17, 2018 at 10:27

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

use sql SELECT nodejs

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related