[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