Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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