MySQL: Can't give tables a name in Upper Camel Case (Pascal Case)

Question

I read that it is best practise to have table names in Pascal Case (ThisIsMyTableName). Therefor I would like to change my tables in MySQL. But neither phpmyadmin, nore SQL Manager 2005 for MySQL will let me. The names stay to appear in lowercase, as if I didn't to a change at all.

Any suggestions to solve this problem?

@Gabe: yes, it is. Windows is not case-sensitive when it comes to MySQL table names, whereas other operating systems generally are. — Matchu, Dec 05 '10 at 19:55
I disagree that this is best practice in MySQL, especially since case-sensitivity in MySQL table names is dependent on the underlying system. Just keep them lowercase and use_underscores. — Matchu, Dec 05 '10 at 19:56

score 8 · Answer 1 · answered Apr 06 '11 at 14:48

8

The easiest way to take care of this is to add the following to your .ini file

lower_case_table_names=2

2 is the significance here for Windows. You can read more about it here Identifier Case Sensitivity

answered Apr 06 '11 at 14:48

swisscheese

1,765
4
23
25

score 4 · Answer 2 · answered Dec 05 '10 at 19:50

4

Use RENAME

example:

RENAME TABLE this_is_my_table_name TO ThisIsMyTableName;

details : http://dev.mysql.com/doc/refman/5.1/en/rename-table.html

answered Dec 05 '10 at 19:50

ajreal

46,720
11
89
119

score 4 · Answer 3 · answered Dec 05 '10 at 19:51

4

In MySQL, you can quote the table names everywhere to make them case preserving and sensitive.

`MyTableName`

answered Dec 05 '10 at 19:51

wallyk

56,922
16
83
148

@PHPst: You would have to do that when creating the table and then every time afterwards. – wallyk Feb 23 '15 at 16:19

score 4 · Accepted Answer · answered Dec 05 '10 at 20:27

4

I advice against mixed case because of problems with case sensitivity. A fully tested solution on one platform where case doesn't matter may actually fail when deployed on a platform where case DOES matter. For that reason alone I suggest sticking with either all caps or all lower case. I use lower case because it is easier on the eye and make spelling errors easier to spot in fixed width fonts used in most editors.

answered Dec 05 '10 at 20:27

Ronnis

12,593
2
32
52

I didnt know that the support of case sensivity in MySQL is dependet of the underlying Operating System. I guess I go for underscore! – Pascal Klein Dec 05 '10 at 22:51

MySQL: Can't give tables a name in Upper Camel Case (Pascal Case)

4 Answers4

Linked

Related