/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 vote139 views1 answer
Default dictionary value
Python
28 votes134 views3 answers
Seaborn size
Python
39 votes164 views6 answers
Creating dataframe
Python
0 vote136 views2 answers
Pip config proxy
Python
9 votes139 views2 answers
Default flask app
Python
76 votes151 views6 answers
For loop in python
Python
0 vote126 views1 answer
Introduction python graphviz simple graph examples
Python
4 votes130 views1 answer
Askopenfilename
Python
0 vote121 views2 answers
NameError: name 'request' is not defined
Python
0 vote130 views3 answers
Assert in python
Python