/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 vote362 views1 answer
Python svg viewing
Python
0 vote348 views1 answer
What is manage.py
Python
0 vote389 views1 answer
Instal django impoer expor
Python Django
16 votes359 views4 answers
Random.choice
Python
4 votes360 views1 answer
Replace multi spaces with single space
Python
0 vote340 views1 answer
83hrs 26 min into minutes
Python
1 vote340 views1 answer
Error bar plot python
Python
0 vote354 views1 answer
Https://stackoverflow.com/questions/55861077/hackerrank-lists-problem-standard-test-case-works-but-others-dont
Python
4 votes402 views6 answers
Counter method in python
Python
0 vote344 views2 answers
How to feature selection in python
Python