Python, MySQL: Getting Null Inserts, but print() is giving value, and SQL is valid?

Question

In the following code:

print(str(processedEmails))
print(campaignId)

returns values I was expecting.

What I'm trying to do (why I ran print() statements to check):

cursor.execute('UPDATE campaigns SET campaign_finish_date = (NOW()) AND queue_size =' + str(processedEmails) + ' WHERE id=' + campaignId)

checking via phpMyAdmin:

NOW() = 0000-00-00 00:00:00.000000
campaignId = 0 (what I set as default)

Values not transferred.

What am I doing wrong?

Community · Accepted Answer · 2017-05-23 11:58:59Z

1

Assuming you're using MySQLdb module, you need to commit() the query if autocommit() is False (default).

See this.

Edit #1:

Then grant that the query is being successfully executed. Have you tried to execute that query via phpMyAdmin? Does it work as expected?

I've noticed that you've a AND instead a comma (',') on your update query:

You've this:

cursor.execute('UPDATE campaigns SET campaign_finish_date = (NOW()) AND queue_size =' + str(processedEmails) + ' WHERE id=' + campaignId)

Instead of this:

cursor.execute('UPDATE campaigns SET campaign_finish_date = (NOW()), queue_size =' + str(processedEmails) + ' WHERE id=' + campaignId)

CommunityBot

11 silver badge

answered May 5, 2014 at 5:01

pah

4,7986 gold badges31 silver badges37 bronze badges

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

2 Comments

Yea--ran into that problem early on, but I have the commit() in my code. Will edit my post to show [but yea...def issue among many people]

that fixed it. heh... syntax :\ ..thank you so much!