回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我的IDE有以下错误:</p>
<blockquote>
<p>MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2102@lionstate.edu', '88zlsj5j', 'Kristopher O'Connell', '21', 'F', 'CMPSC', '77' at line 1")</p>
</blockquote>
<p>以下是导致错误的部分代码:</p>
<pre><code>for a, b, c, d, e ,f, g, h in zip(df_stu['Email'], df_stu['Password'], df_stu['Full Name'], df_stu['Age'], df_stu['Gender'], df_stu['Major'], df_stu['Street'], df_stu['Zip']):
cursor.execute("INSERT INTO LSU.Student (Semail, Spassword, Sname, Sage, Sgender, Smajor, Sstreet, Szipcode) "
"VALUES ('%s', '%s', '%s', '%d', '%s', '%s', '%s', '%d')" % (a, b, c, d, e, f, g, h))
</code></pre>
<p>这是我的创建表:</p>
^{pr2}$
<p>这在我看来是正确的,但是IDE一直说存在语法错误。在</p>