Skip to content

Instantly share code, notes, and snippets.

@blt
Created Jun 7, 2011
Embed
What would you like to do?
ERROR 1064 (42000): 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 'WHERE NOT EXISTS ( SELECT id FROM PlatonicBridgeUser WHERE jid= ' at line 1
INSERT INTO PlatonicBridgeUser (jid)
SELECT 'troutwine@jabber.org'
WHERE NOT EXISTS (
SELECT id FROM PlatonicBridgeUser
WHERE jid= 'troutwine@jabber.org'
)
CREATE TABLE PlatonicBridgeUser (
id SERIAL NOT NULL PRIMARY KEY,
jid text NOT NULL UNIQUE
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment