/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

8 votes138 views2 answers
Django create empty migration
Python
1 vote150 views2 answers
Python list equality
Python
0 vote134 views1 answer
Seaborn heatmap parameters
Python
16 votes157 views6 answers
Joins in pandas
Python
0 vote152 views1 answer
Use colabs gpu locally
Python
84 votes148 views6 answers
Sort dataframe by column
Python
2 votes203 views1 answer
Tan for python
Python
0 vote142 views2 answers
Closures in python
Python
3 votes288 views2 answers
List images in directory python
Python
10 votes145 views4 answers
Load model tensorflow
Python