/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 vote103 views1 answer
Pandas select data by column value
Python
0 vote136 views1 answer
When training= false still dropout
Python
2 votes131 views1 answer
How to split and keep delimiter at the same line in python
Python
1 vote137 views1 answer
Seconds in a month
Python
0 vote132 views1 answer
Add system path python jupytre
Python
4 votes213 views2 answers
Authentication views django
Python Django
2 votes141 views2 answers
Months list python
Python
59 votes147 views6 answers
How to split word in python
Python
1 vote156 views2 answers
Python return using if
Python
0 vote99 views2 answers
Python remove empty lines
Python