/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

1 vote174 views1 answer
Sklearn accuracy
Python
0 vote171 views1 answer
Django cms create page programmatically
Python
3 votes197 views2 answers
Python extract specific columns from pandas dataframe
Python
9 votes169 views3 answers
Difference between two dates in days python
Python
0 vote176 views1 answer
Django model different schema
Python
0 vote181 views2 answers
Django rest framework authentication
Python Django
0 vote173 views1 answer
Waitress serve
Python
0 vote161 views1 answer
Python inherit from objects
Python
1 vote163 views5 answers
Transpose matrix python
Python
1 vote236 views1 answer
Matplotlib log2 xaxis
Python