Python

Search

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()

Comment

PREVIOUS	NEXT

Code Example
Python :: get the values of your aws tags from ec2 instance
Python :: how to move a specific row to last row in python
Python :: EMAIL_BACKEND where to read
Python :: list alpha numeric
Python :: set_flip_h( false )
Python :: python selenium for desktop application
Python :: django is .get lazy
Python :: discord.py get user input (simplified)
Python :: how to use lambda function in python
Python :: Form rendering options in django
Python :: pytorch rolling window
Python :: use an async check function for discord.py wait_for?
Python :: mechanize python XE #29
Python :: python import shelve
Python :: append to a list without intializing
Python :: example of python application from github to docker image
Python :: pandas str contains only true
Python :: # merge two dictionaries
Python :: scipy z value to pvalue
Python :: python sorted vs sort
Python :: create view django not saving image
Python :: import image files from folders
Python :: matplotlib insert small subplot into subplot
Python :: Python 2 vs Python 3 Print Statement
Python :: Add 1 to loops
Python :: lambda2 criterion python
Python :: transfer learning in python with custom dataset
Python :: Python NumPy atleast_3d Function Example
Python :: manipulate sns legend
Python :: Python NumPy block Function Example by using simple array

Search

PYTHON

how to check if a column exists before alter the table

ADD CONTENT