heidisql - create database with uppercase Camel Case Format

Question

i create table with Tbl-ProductModifierGroup but on HeidiSQL it will display tbl-productmodifiergroup, how to slove this problem? Can i create table with CamelCase Format? which is Tbl-ProductModifierGroup

Answer 1

Just set the server variable lower_case_table_names to the value of 0 in your my.ini file:

[mysqld]
lower_case_table_names=0

But be aware of side effects mentioned on https://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html