/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 vote200 views1 answer
Python split large xml file by tag
Python
0 vote229 views2 answers
Javascript parse url
Python
0 vote195 views1 answer
Como eliminar palabras repetidos de una lista python
Python
1 vote186 views1 answer
Create dictionary key and values from lists
Python
0 vote195 views1 answer
Pil
Python
6 votes195 views2 answers
Python writeline file
Python
0 vote188 views2 answers
Django query string route
Python
0 vote183 views1 answer
Save this RDD as a SequenceFile of serialized objects
Python
28 votes202 views2 answers
Tofixed in python
Python
2 votes182 views1 answer
Dictionary with numbers python
Python