Insert login name from a table into another table, But don't if it exists.

[gergy008]

Get where I'm coming from? It's bugging me, I thought this would work but no!!

 

INSERT INTO `gaming` ('login') SELECT `login` FROM `users` WHERE (NOT EXISTS (SELECT `login` FROM `gaming`))

[taquitosensei]

I think you're looking for not in

INSERT INTO `gaming` ('login') SELECT `login` FROM `users` WHERE `login` not in (SELECT `login` FROM `gaming`)

[gergy008]

I think you're looking for not in

INSERT INTO `gaming` ('login') SELECT `login` FROM `users` WHERE `login` not in (SELECT `login` FROM `gaming`)

 

Sorry it is saying syntax error, I think it might be where the ('login') is, But I have no idea. Anyone have any ideas why it says syntax error?

[premiso]

Because login is a column and if they are denoted they need to be denoted by back ticks ( ` ) and not single quotes ( ' ). Fixing that should get it to work (I tested a similar version on my server).

 

INSERT INTO `gaming` (`login`) SELECT `login` FROM `users` WHERE `login` not in (SELECT `login` FROM `gaming`)