Solved

How to make MySQL use capital letters when creating tables?

Posted on 2013-12-29
4
85 Views
Last Modified: 2016-05-27
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
Comment
Question by:Eduardo Fuerte
4 Comments
 
LVL 13

Accepted Solution

by:
Carl Bohman earned 500 total points
ID: 39744698
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
 

Author Comment

by:Eduardo Fuerte
ID: 39746115
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now