/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 vote116 views1 answer
Earthpy
Python
0 vote94 views1 answer
Gzip folder python
Python
24 votes111 views1 answer
Creating a new enviroment in conda
Python
21 votes65 views5 answers
Tkinter window
Python
0 vote97 views1 answer
Python silent DeprecationWarning
Python
2 votes90 views3 answers
How to open file explorer in python
Python
0 vote178 views1 answer
Python catch output to terminal
Python
0 vote113 views2 answers
Copy only some columns to new dataframe in r
Python
1 vote97 views1 answer
F string round
Python
13 votes114 views1 answer
Python clear the printed text
Python