[dba-Tech] MySQL Syntax: Fresh eyes needed

MySQL doesn't do backquotes. 

Peter is probably right - I didn't pick that they were single quotes and not backticks.

-- 
Stuart

On 16 Mar 2013 at 7:43, Rocky Smolin wrote:

> OR does it need brackets like [Last Name]?
> 
> R
>  
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Saturday, March 16, 2013 6:51 AM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] MySQL Syntax: Fresh eyes needed
> 
> Try 'customers.Last Name' instead of customers.`Last Name' etc
> 
> --
> Stuart
> 
> On 16 Mar 2013 at 8:35, Arthur Fuller wrote:
> 
> > I've been staring at this expression too long and my eyes are 
> > beginning to
> > cross:
> > <,mysql>
> > SELECT
> > IF(ISNULL(customers.`Last 
> > Name`),customers.Company,CONCAT(customers.'First
> > Name',' ', customers.'Last Name')) as 'File As:'
> > from `customers`
> > </mysql>
> > 
> > Syntax error. The Concat() part works fine in isolation so the problem 
> > is not there
> > 
> > TIA,
> > Arthur
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>