/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

10 votes150 views5 answers
Zip python
Python
8 votes215 views6 answers
Pandas groupby
Python
0 vote190 views1 answer
K means image classification
Python
1 vote154 views1 answer
Location of last row dataframe
Python
0 vote151 views1 answer
Python break list into n lists
Python
10 votes251 views6 answers
Dich
Python
2 votes153 views3 answers
WARNING: pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available.
Python
2 votes167 views1 answer
How to print palindrome in 100 between 250 in python
Python
2 votes161 views1 answer
Convert float in datetime python
Python
3 votes169 views2 answers
Convert mb to gb python
Python