insert into python mysql not updating in DB

Question

I tried inserting the values into the DB through python. However i do not get any error but i do not see it updating in DB. Please advice.

#!/usr/bin/python

import MySQLdb

val = MySQLdb.connect(host='localhost', user='root', passwd='root123', 
db='expenses')

def access_db(val):
    access = val.cursor()
    sql = """Insert into monthly values (2,'Food',1000)"""
    access.execute(sql)
 val.commit()
 val.close()

Output from DB after the script execution:

MariaDB[expenses]> select * from monthly;
SL_no     Type    Amount
  1       Fuel     500

I do not find the second entry in Db.

DollarAkshay · Accepted Answer · 2019-01-16 16:51:30Z

1

I dont think you are calling the access_db() function anywhere

answered Jan 16, 2019 at 16:51

DollarAkshay

2,1191 gold badge21 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bhargav Mg Over a year ago

My bad. Thanx for the help

Collectives™ on Stack Overflow

insert into python mysql not updating in DB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related