• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

How to make MySQL use capital letters when creating tables?

Hi Experts!

I'm facing a problem when migrating a MySQL database hosted at internet to my local machine.

First I obtained the backup script at host and then run it locally.

The local table names are created with lower case names even the script used it in capital letters.

Since I'd like to make the table names exactly the same to avoid problems between the 02 databases (I'm planning to develop sp(s) and get then returned to net)  how to workaround that?

01
Thanks in advance!
0
Eduardo Fuerte
Asked:
Eduardo Fuerte
1 Solution
 
Carl BohmanCommented:
Found this bit of documentation:

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Apparently, MySQL normally defaults to lower case and searches in a case-insensitive manner.

Are any of your tables mixed case or do you have any two tables with the same name but different case?  If not, you probably don't need to worry about the case of the tables.
0
 
Eduardo FuerteAuthor Commented:
Hello

The way I wrote the script is all the same manner as in the picture.

But I realized that if using the same names from the net in the local DB (capital letters at table's names) no error occurs - the opposite isn't true.

Since the major worry is develop locally (with debug facility) and put at net then
it's a relief...
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now