I have a database that was created years ago by an office manager in Access. It was then moved to MySQL at some point, but many of the column headers have spaces in their names. This has always made things a pain in the butt.
Now, I am being allowed to get rid of these spaces. The question is, can I do this with an SQL statement? I have copied the entire database to a new instance and can mess with it all I want. I want to bring all of the most current data over and change the header names... just not sure if I have to go and hand rename them all.... which is about 200 of them.
Any help is appreciated!