Over the last year I've collected a few tables with names like "#Tableau_sid_0000082E_7_none_RegCountry_nk" in my MySQL DB. I believe these are due to connections that were lost along the way. I'm not concerned with how they got there. What I'd like to know is how to drop them as I can't tell how to escape the comment character '#'.
I've tried various combinations with 'drop table'. But I'm not hitting on the correct character escaping or quoting to get rid of them. I get either "ERROR 1064 (42000) at line 1: You have an error in your SQL syntax..." or "ERROR 1051 (42S02) at line 1: Unknown table...". And the documentation that I thought would address this doesn't: