[GLLUG] use SQL reserved words as field names
Basher584
basher584 at basher584.org
Wed May 24 02:33:36 EDT 2006
I believe you want the back tick.. `keyword`
http://dev.mysql.com/doc/refman/5.0/en/legal-names.html
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
-Ben
On Wed, May 24, 2006 at 02:29:03AM -0400, Caleb Cushing wrote:
> well I tried... using "show" and [show] neither of those worked... syntax
> error. I was thinking maybe that I could use some kind of character escape
> to do it much like in say BASH if I really want to I can make echo '$SHELL'
> print $SHELL instead of /bin/bash this database I'm playing with isn't
> important just a sample from a book... but it wasn't written for mysql. and
> is Fairly old although the samples should be built around ANSI SQL-92 anyway
> guess somedays I'm just not thinking.
> _______________________________________________
> linux-user mailing list
> linux-user at egr.msu.edu
> http://mailman.egr.msu.edu/mailman/listinfo/linux-user
More information about the linux-user
mailing list