[GLLUG] use SQL reserved words as field names

[Caleb Cushing]

thanks that did it... like I said this really wasn't important more or less
just something it seems like I should know. even if using a reserved word is
BAD design...

On 5/24/06, Basher584 <basher584 at basher584.org> wrote:
>
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.egr.msu.edu/mailman/public/linux-user/attachments/20060524/1d0eb6fb/attachment.html