/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 vote267 views1 answer
Selenium python find all links
Python
2 votes275 views1 answer
Check corently installed epython version
Python
4 votes290 views3 answers
AttributeError: module 'tensorflow._api.v2.train' has no attribute 'GradientDescentOptimizer' site:stackoverflow.com
Python
3 votes241 views1 answer
Delete a key value pair from a dictionary in python
Python
1 vote295 views1 answer
Python validate url
Python
3 votes291 views1 answer
How to connect templates in django
Python Django
0 vote251 views1 answer
Python args description multiple lines
Python
0 vote256 views1 answer
Sentence transformers
Python
5 votes286 views3 answers
ModuleNotFoundError: No module named 'StringIO'
Python
1 vote276 views2 answers
Python write json to file utf8
Python