/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

36 votes101 views6 answers
Get list file in folder python
Python
35 votes109 views2 answers
Pwd python
Python
0 vote112 views1 answer
Function used in python
Python
12 votes101 views6 answers
Intersection of two lists python
Python
-3 votes117 views5 answers
Multiplication table in python
Python
3 votes132 views1 answer
Django flush
Python Django
0 vote109 views1 answer
Python remove middle of string
Python
0 vote115 views1 answer
Form rendering options in django
Python
0 vote106 views1 answer
Read .fasta python
Python
0 vote117 views1 answer
Suffixes in pandas
Python