/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 vote143 views1 answer
Install open3d jetson nano aarch64
Python
1 vote134 views2 answers
What is fourier transform in python
Python
0 vote135 views2 answers
Closures in python
Python
12 votes147 views3 answers
Get size of window tkinter
Python
0 vote161 views1 answer
Eager tensor to numpy
Python
0 vote145 views1 answer
Python hewwo world
Python
0 vote118 views1 answer
R stagazer html knit
Python
0 vote158 views1 answer
Django model manager user
Python Django
2 votes149 views2 answers
Convert list to generator python
Python
0 vote131 views1 answer
Python add commas to list
Python