SQLite Updating records

SQLite

We are using our student table. Check how to create database and student table here.

Read more on UPDATE query here.

Update single column

We will add 5 mark to student with id=7
q="update student set mark=mark+5 WHERE id =7"
r_set=my_conn.execute(q)
print("Records updated")


  • Video Tutorial on SQLite UPDATE Query



Updating multiple columns with error printing

We can display error message if there is any error by using try except . We will also update all class Four to class Five.
q="UPDATE student set class='Five' WHERE class='Four' "
try:
    r_set=my_conn.execute(q)
    print("Records updated")
except sqlite3.Error as my_error:
  print("error: ",my_error)
Output
Records updated

Number of records updated

We can display number of rows updated by using rowcount, output is 9
print(r_set.rowcount) # 9 

Using SQLAlchemy

from sqlalchemy.exc import SQLAlchemyError
q="UPDATE STUDENT set mark=mark+1"
try:
  r_set=my_conn.execute(q)
except SQLAlchemyError as e:
  error=str(e.__dict__['orig'])
  print(error)
else:
  print("No of records updated : ",r_set.rowcount)

Using Parameters


We have used placeholders ( ? ) in our query and note that my_data is a tuple used for passing value to execute() method for our query.

We have used rowcount to display number of rows affected or updated.
my_data=('Seven','Six') # tuple to pass values to execute method
q="UPDATE student set class=? WHERE class=? "
try:
    r_set=my_conn.execute(q,my_data)
    print("Records updated : ",r_set.rowcount)
except sqlite3.Error as my_error:
  print("error: ",my_error)
Output
Records updated :  1
Updating single records
q="update student set mark=mark+5 WHERE id =9"
r_set=my_conn.execute(q)
print("Records updated : ",r_set.rowcount)
Output
Records updated :  1
Sqlite Connection insert Delete select Order By

Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com



    Post your comments , suggestion , error , requirements etc here





    Python Video Tutorials
    Python SQLite Video Tutorials
    Python MySQL Video Tutorials
    Python Tkinter Video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2021 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer