Since Mac OS X is Unix it should use the same rules as a Unix machine
when it comes to MySQL and case sensitivity of table and database
names. According to Dubois: "DB and tables in MySQL correspond to
directories and files in the underlying file system on the server
host. As a result, case sensitivity of db and table names depends on
the way the OS on the host treats filenames. A server running on UNIX
treats db and table names as case sensitive since UNIX filenames are
case sensitive."
However, I don't find this to be true on Mac OS X. In the following,
I show that I have a table "Menu" (with capital M) but am able to
insert or select using the lower case "menu". Is there any
explanation for this?
mysql> show tables;
+----------------------+
| Tables_in_bPublished |
+----------------------+
| Menu |
+----------------------+
1 row in set (0.00 sec)
mysql> select * from menu;
<snip ... etc ... >
6 rows in set (0.01 sec)
mysql> INSERT INTO menu VALUES ('',3,1,'Cat Stuff','Cat
Stuff','/images/icons/Cat.gif',2), ('',4,1,
'Zebra Stuff','Zebra Stuff','/images/icons/Zebra.gif',2);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 2
mysql> select * from Menu;
<snip ... etc ... >
8 rows in set (0.00 sec)
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
