1 Reply Latest reply on Mar 24, 2014 8:07 PM by Daniel Seisun

    How to drop Tableau_sid tables in MySQL

    Rob Reid

      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:


      MySQL :: MySQL 5.5 Reference Manual :: 9.1.1 String Literals