/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

3 votes264 views1 answer
Python spammer
Python
11 votes227 views3 answers
How to get length of string in python
Python
1 vote288 views1 answer
Auto-created primary key used when not defining a primary key type, by default 'django.db.models.AutoField'.
Python Django
0 vote214 views1 answer
Flask on gevent over https
Python
5 votes247 views3 answers
How to convert array value to integer in python
Python
0 vote230 views1 answer
How long is the pyautogui script
Python
1 vote233 views1 answer
How to open an external file in python
Python
18 votes264 views5 answers
Pandas replace na with 0
Python
9 votes242 views1 answer
Delete model object django
Python Django
0 vote251 views1 answer
Question command python
Python