title: How to convert MySql column names to lowercase for better readability?
body: <p>I've got a db with a dozen of tables inside of it that have irregularity regarding the low- and uppercase usage. Is there a simple way to convert all column names in all mysql-tables to lowercase ? Maybe with the exception of strings ending with "_ID"? </p>
  
  <p><strong>I know that mysql isn't case sensitive.</strong> This is all about better readability. If you have column names like "Author", "AUTHOR_ID" and "AuthorName" in one table it's hard to read and I like to have it more consistent using lowercase. </p>