擅长:python、mysql、java
<p>您需要检查表以查看列是否存在:</p>
<pre><code># replace your_table with your table you want to inspect
existing_cols = [row.column_name for row in cursor.columns(table='your_table')
# check if the column you want to add is in the list
if col_add in existing_cols:
pass # do nothing
else:
# alter table
# replace your_table with the table you want to alter
# replace varchar(32) with the data type for the column
cursor.execute("ALTER TABLE your_table ADD COLUMN {} varchar(32)".format(col_add)
con.commit()
</code></pre>