/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 vote197 views1 answer
How to apply sentence case in python
Python
1 vote194 views1 answer
Django sort descending
Python Django
0 vote191 views3 answers
Pip proxy settings
Python
11 votes203 views2 answers
Pandas left join
Python
0 vote195 views1 answer
Django project files
Python
3 votes204 views1 answer
PowerShell says “execution of scripts is disabled on this system.”
Python
0 vote183 views1 answer
Como escribir letras griegas en python
Python
1 vote194 views1 answer
Split data train, test by id python
Python
1 vote195 views1 answer
Explode dictionary pandas
Python
8 votes189 views5 answers
Find common elements in two lists python
Python