/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

74 votes275 views6 answers
Append dictionary python
Python
0 vote275 views1 answer
Maximum number of charectors allowed for a string variable in python
Python
0 vote291 views1 answer
What is require_self
Python
0 vote236 views1 answer
Displaying cv2.imshow on specific window position
Python
1 vote260 views2 answers
How to print without space in python 3
Python
4 votes274 views2 answers
Django composite primary key
Python
0 vote280 views1 answer
Python cron job virtualenv
Python
4 votes303 views2 answers
How to count non null values in pandas
Python
2 votes277 views2 answers
Django template array index
Python
0 vote338 views1 answer
Get table wikipedia
Python