update column value using python script has no effect on table

Question

I have added new column to the existing mysql table with default value as '0'. Ia m trying to update those values to '1' using python script but it does not have any effect on the table.

on the log

SELECT * FROM `customer_1`.`violations` WHERE 0=1

this is my python script:

#!/usr/bin/env python

import os, sys
from mydb import cursor
from twisted.enterprise import util as dbutil
from MySQLdb import escape_string



sql ="UPDATE `customer_1`.`violations` SET `flag`='1' WHERE `flag`='0' ";

print sql
cursor.execute(sql)

It works when I run the same statment on mysql.

Thanks

Remove the quotes from 0

Mihai
– Mihai

2015-11-18 15:18:25 +00:00
Commented Nov 18, 2015 at 15:18 — Mihai
– Mihai, Commented Nov 18, 2015 at 15:18
Tried that still the same error.

Nisha
– Nisha

2015-11-18 15:21:41 +00:00
Commented Nov 18, 2015 at 15:21 — Nisha
– Nisha, Commented Nov 18, 2015 at 15:21

DeepSpace · Accepted Answer · 2015-11-18 15:14:44Z

1

Don't you need to do commit after execute the statement?

cursor.commit()

edited Nov 18, 2015 at 15:14

DeepSpace

82.1k12 gold badges119 silver badges166 bronze badges

answered Nov 18, 2015 at 15:13

Ildelian

1,3185 gold badges16 silver badges42 bronze badges

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

1 Comment

Nisha Over a year ago

AttributeError: 'Cursor' object has no attribute 'commit' -error

Collectives™ on Stack Overflow

update column value using python script has no effect on table

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