擅长:python、mysql、java
<p>在MySQL中,schema对象与SQL参数不同,有不同的引号规则,schema对象的引号是反勾(`):</p>
<blockquote>
<p>An identifier may be quoted or unquoted. If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it. (Exception: A reserved word that follows a period in a qualified name must be an identifier, so it need not be quoted.) Reserved words are listed at Section 9.3, “Keywords and Reserved Words”.</p>
<p>...</p>
<p>The identifier quote character is the backtick (`):</p>
</blockquote>
<p>您可以这样修改代码:</p>
<pre><code>query2 = "DROP TABLE IF EXISTS `%s`"
...
cursorDrop.execute(query2 % tableName)
</code></pre>
<p>有关<a href="https://dev.mysql.com/doc/refman/5.5/en/identifiers.html" rel="nofollow noreferrer">MySQL doc</a>的详细信息,请参阅。在</p>