/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 vote315 views1 answer
Switch between frames in tkinter
Python
6 votes368 views4 answers
Media django
Python Django
0 vote305 views1 answer
Get index of max value python numpy
Python
0 vote340 views1 answer
How to add another timestamp column plus two hours
Python
2 votes328 views1 answer
Extract text regex python
Python
0 vote323 views1 answer
Numpy savetxt list of strings
Python
0 vote309 views1 answer
Class 10: Conditional Statements in Python [IF, ELIF, ELSE]
Python
1 vote368 views1 answer
How to add char to string python
Python
0 vote323 views1 answer
Sqlalchemy datetime default now create table
Python
9 votes328 views1 answer
How to convert a set to a list in python
Python