help with a SELECT query

#1

Hi all, I have tables with columns names containing dots and I'm trying to
build up queries as in:

select it.n.cuore.1.lemma from a027;
But I get errors complaining about a syntax error.

I have been told that for names containing special chars need to be wrapped
by squared brackets as in:

select [it.n.cuore.1.lemma] from a027

but I get the same error.
Can someone help me?

#2

halex2000 wrote:

Quote:

Hi all, I have tables with columns names containing dots and I'm trying to
build up queries as in:

select it.n.cuore.1.lemma from a027;
But I get errors complaining about a syntax error.

I have been told that for names containing special chars need to be
wrapped by squared brackets as in:

select [it.n.cuore.1.lemma] from a027

but I get the same error.
Can someone help me?

Use backticks.

SELECT `it.n.cuore.1.lemma` FROM a027;

--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png

#3

This works, thanks!

"Brian Wakem" <no (AT) email (DOT) com> ha scritto nel messaggio
news:4j4im4F6748pU1 (AT) individual (DOT) net...

Quote:

halex2000 wrote:

Hi all, I have tables with columns names containing dots and I'm trying
to
build up queries as in:

select it.n.cuore.1.lemma from a027;
But I get errors complaining about a syntax error.

I have been told that for names containing special chars need to be
wrapped by squared brackets as in:

select [it.n.cuore.1.lemma] from a027

but I get the same error.
Can someone help me?

Use backticks.

SELECT `it.n.cuore.1.lemma` FROM a027;

--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

help with a SELECT query

comp.databases.mysql comp.databases.mysql

help with a SELECT query - 07-30-2006 , 03:19 PM

Re: help with a SELECT query - 07-30-2006 , 03:21 PM

Re: help with a SELECT query - 07-30-2006 , 03:34 PM