On 2014-05-16 17:32, [email protected] wrote:
I'm having a discussion with my ISP about the MySQL database he's
hosting for me. Apparently he's got a switch on where the EXACT
SPELLING of the table (and probably field name) is important.
If I've got a table named luCrap then I want to be able to do the
following SQLs and have them all work:
select * from luCrap
select * from lucrap
select * from LUCRAP
He asks me "Why would anyone want to do that?" lol I replied:
"Well, that's just how my code is sometimes!" Honestly, why the hell
would I want two DIFFERENT tables named the same but in different
casing? How confusing is that?!?!?????
What am I missing from all of this?
It's being hosted on a Linux server but I thought there was a way to set
MySQL (actually MariaDB) to ignore table name casing so it's all the
same. ??
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
