/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

3 votes324 views2 answers
Python multiply list by scalar
Python
0 vote289 views1 answer
Proper function pandas
Python
0 vote291 views1 answer
Minmaxscaler transform
Python
3 votes302 views2 answers
Requests post with headers python
Python
96 votes328 views6 answers
Read json file
Python
0 vote306 views1 answer
Matplotlib colorbar reverse direction
Python
1 vote314 views3 answers
Count function in python
Python
0 vote319 views1 answer
Python if not explaned
Python
13 votes317 views2 answers
Map function using lambda in python
Python
0 vote315 views1 answer
How to have requirement file in python for libs
Python