/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 vote178 views1 answer
Python pickle 'ascii' codec can't decode byte 0x80 in position 0
Python
0 vote181 views1 answer
Sql like equivalent in python
Python
1 vote174 views1 answer
How to generate random normal number in python
Python
21 votes194 views6 answers
Install pygame
Python
0 vote183 views1 answer
Hewwo world
Python
1 vote163 views1 answer
Qmessagebox icon pyqt5
Python
0 vote179 views1 answer
Extract label from tf data
Python
0 vote171 views1 answer
How to read backslash slash python
Python
0 vote178 views1 answer
Python ip address increment
Python
0 vote187 views1 answer
Python str and repr
Python