Case (in)sensitive

Dear MySQL,
why if I use a query like this:

"select customer.id, Customer.company_name
from Customer"

I receive:
"Unknown table 'customer' in field list"

if tables name (and fields name) are case insensitive also alias should be. Or not?

Thanks in advance

Nicola Biada




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Case (in)sensitive

Nicola Biada writes:
> Dear MySQL,
> why if I use a query like this:
>
> "select customer.id, Customer.company_name
> from Customer"
>
> I receive:
> "Unknown table 'customer' in field list"
>
> if tables name (and fields name) are case insensitive also alias should be. Or not?
>
> Thanks in advance
>
> Nicola Biada


Hi!

Only on Windows and OS X table names are case insensitive.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org