/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 vote195 views1 answer
Pandas pivot to sparse
Python
0 vote173 views1 answer
Getting python class from string
Python
1 vote206 views1 answer
How to iterate pyspark dataframe
Python
2 votes198 views2 answers
Tkinter button foreground color click
Python
219 votes599 views6 answers
Random numbers python
Python
1 vote223 views1 answer
Pygame mute import message
Python
3 votes172 views2 answers
Command for python shell
Python
0 vote186 views1 answer
Tar: Exiting with failure status due to previous errors
Python
0 vote184 views1 answer
Python run module with and without "-m" option and import path setting
Python
-1 vote209 views1 answer
How to scan directory recursively python
Python