擅长:python、mysql、java
<p>是的,你可以,但你应该这样做</p>
<pre><code>sql = "SELECT course_id, creator_id, course_num, record_id FROM Courses"
all = cursor.fetchall()
for i in range(len(all))
sql1 = "INSERT INTO Courses (course_id, creator_id, course_num, record_id) VALUES (%s, %s, %s, %s)"
cursor.execute(sql1, (all[i]['Key'], all[i]['Key2'], all[i]['Key3'], all[i]['Key3']))
</code></pre>
<p>您可以随心所欲地更改select,记住返回一个dictionary,所以要注意键,添加<code>print(all)</code>以查看select的结果,并查看每列的键</p>