I've been creating table names using mixtures of capital letters and small letters but when it appeared on phpMyAdmin, all names are in small letters.
Is it a problem with my phpMyAdmin settings or mysql? and how do i solve it.
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. This means database and table names are case sensitive in most varieties of Unix, and not case sensitive in Windows.
yes im on windows, thanx for the link it was very helpful.
would you recommend sticking with lower case for all table/databse names if i were to transfer tables between platforms that differ in filesystem case sensitivity?