[dba-Tech] MySQL Syntax: Fresh eyes needed

On 2013-03-16 9:43 AM, Rocky Smolin wrote:
> OR does it need brackets like [Last Name]?

MySQL doesn't support brackets. Requires backticks.

PB

>
> 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
>