/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

0 vote116 views1 answer
Quill get content flask
Python
0 vote174 views2 answers
Plt.xlabel not working
Python
9 votes142 views2 answers
Flask flash
Python Flask
0 vote105 views2 answers
Matplotlib twinx legend
Python
36 votes106 views6 answers
Get list file in folder python
Python
2 votes122 views2 answers
Sigmoid in python from scratch
Python
0 vote117 views1 answer
ValueError: Invalid format specifier
Python
0 vote136 views1 answer
Loading model
Python
46 votes114 views6 answers
Add row to dataframe
Python
68 votes129 views6 answers
Python clear console
Python