/Python/How to check if a column exists before alter the table

How to check if a column exists before alter the table

conn = sqlite3.connect(':memory:')
c = conn.cursor()
try:
    c.execute('ALTER TABLE mytable ADD COLUMN newcolumn;')
except:
    pass # handle the error
c.close()

Source: stackoverflow.com

Similar codes

4 votes162 views1 answer
Making a function wait in python
Python
0 vote151 views1 answer
Nunique sort
Python
3 votes154 views1 answer
Pandas plotly backend
Python
5 votes189 views2 answers
Click button in selenium python
Python
0 vote152 views1 answer
Matplotlib styles attr
Python
8 votes166 views6 answers
Remove outliers python pandas
Python
0 vote179 views1 answer
PY | websocket - server
Python
0 vote160 views1 answer
Violin Plot Seaborn
Python
0 vote163 views1 answer
Python docx extract image
Python
0 vote146 views1 answer
Python sys.argv exception
Python