I imported my MySQL database tables to Amazon RDS. My problem is that my queries don't longer work and I get an error that my table 'Folders' doesn't exist. The reason for that is that the table names are not all with the lower casing, which causes the query to throw this error.
Is there a way to change the table name with one with uppercase using MySQL Workbench against Amazon RDS database. I tried using 'alter table', but it gives me an error "Selected name conflicts with exists table' when I try to rename to the same name and changing to a capital letter. Any ideas on how to solve this?
Maybe there is an option to tell Amazon RDS to ignore table name and table field's capitalization.
Back