On 16 January 2015 at 18:24, justin chaise <justinchaisej...@gmail.com> wrote:
> this is an old post, but still i will comment. I ran into this myself and a
> quick answer would have been nice.
>
> mysql sees the field named key as a reserved word. At the mysql commandline
> i enclosed the field name key with backticks `key`.
> I was then able to add my users via the command line.

Ah, thanks Justin! I ran into a very similar issue myself yesterday
because 'user' is a reserved word in PostgreSQL. There you have to use
double quotes around the field names instead.

SQL is such fun :)

Regards,
Matthew

-- 
You received this message because you are subscribed to the Google Groups 
"prosody-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to prosody-dev+unsubscr...@googlegroups.com.
To post to this group, send email to prosody-dev@googlegroups.com.
Visit this group at http://groups.google.com/group/prosody-dev.
For more options, visit https://groups.google.com/d/optout.

Reply via email to