
This is the warming message in MySQL Workbench shown if value of lower_case_table_names equal to Object, MySQL Workbench would convert table name which's started capital letter to all lower case letters, for example, table name "Course" would be converted to "course".
Step 1
If you still want to create a table started with capital letter, you can open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini , for example: C:\xampp\mysql\bin\my.ini:
Step 2
Search for the text "# The MySQL server" and add "lower_case_table_names = 2" below the line of [mysqlId]lower_case_table_names = 2
No comments :
Post a Comment