Blog2Works

This is the blog of freelance website designer and developer Ben Johnson, with thoughts on design, programming, frameworks, jquery and the latest technology.
Viewing entries tagged with 'tables'
  • camelCase Table Names using WAMP on Windows

    Author: Ben Johnson

    Tags: , , , ,

    When developing websites at Web2Works to ensure all our projects are of a high standard one of our standards is using the CamelCase naming conventions set by Zend Framework http://framework.zend.com/manual/en/coding-standard.naming-conventions.html If you are using a WAMP or XAMPP, and try to create a table in camelCase (example: AdminLogin) you will notice that camelCase is not working, table name will be lowercase: adminlogin. In order to fix this, you need to add to your my.cnf file the line: lower_case_table_names=2 and restart mysql. Although please note that once you have turn on this setting you can't go back. "ButThenWhyWouldYouWantToEverGoBackCamelCasingIsCool"