Solved

How to make MySQL use capital letters when creating tables?

Posted on 2013-12-29
4
90 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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

15 Experts available now in Live!

Get 1:1 Help Now