/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

2 votes163 views1 answer
Python read text file look for string
Python
0 vote154 views1 answer
Start of the american labor movement
Python
0 vote145 views1 answer
Python find cursor position
Python
0 vote175 views1 answer
Intellij python
Python
0 vote212 views1 answer
Python send commands in one line but write in multiple
Python
15 votes167 views6 answers
Value_counts() in pandas
Python
0 vote173 views1 answer
Capitalize first word of a phrase in python
Python
0 vote161 views1 answer
Clear All the Chat in Discord Channel With Bot Python COde
Python
1 vote175 views1 answer
Python print dict new line
Python
1 vote170 views1 answer
Alarm when code finishes
Python