0

Everytime i try to create a new table from a schema with a capital first letter i have i have the message the server is configured with lower_case_table_names=1 ..., i checked for solutions and i found this link, i found the my.ini file in ProgramData also mentioned here, i added the value lower_case_table_names = 2 at the end of the file since there was no # The MySQL server [mysqld] at least in that file. But nothing happened, i still have the same message. I need the tables upper cased because i have to run scripts to populate them. I also noticed the threads were a couple of years old maybe there's an option to set inside the program ?

Community
  • 1
  • 1
user6008337
  • 221
  • 3
  • 15
  • Did you restart mysqld after editing the config file? – Eric J. Mar 03 '16 at 21:56
  • I restarted mysql and now everytime i try to create a new table i have this error "Operation failed: There was an error while applying the SQL script to the database. Executing: CREATE TABLE `toys`.`test` ( ); ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL Statement: CREATE TABLE `toys`.`test` ( ) " – user6008337 Mar 03 '16 at 22:59
  • Sounds like your configuration change took hold after restarting the server. Suggest you open up a new question about CREATE TABLE including the full create command that you issued (column names, data types, etc). – Eric J. Mar 03 '16 at 23:19
  • I don't believe they couldn't simply add a simple option to do this ... – user6008337 Mar 03 '16 at 23:35

0 Answers0