python mysql update timestamp

Question

Hi I need help understanding how to update just the timestamp column independent of any column. I've been searching on google for an example of this but I don't see any relevant examples. Below I've pasted code that does it for ID = 1 for testing purposes but there was no update to the time for ID = 1. My goal though is to update the timestamp for all rows regardless of the column name.

*TLATemplate already contains column called 'timestamp' *config is a module that has imported time

Thank you!

Below is my code:

sql = "CREATE TABLE %s like TLAKnoxT5Template" %TLA_dict['TLA_name']
config.cursor.execute(sql)
config.db.commit()
#copy entire table
sql = "INSERT INTO %s SELECT * FROM TLAKnoxT5Template"%TLA_dict['TLA_name']
config.cursor.execute(sql)
config.db.commit()

#update timestamp
sql = "UPDATE %s SET TIMESTAMP = %s WHERE ID = 1"%   
(TLA_dict['TLA_name'],config.time.strftime("%Y-%m-%d %H:%M:%S",/
config.time.localtime(config.time.time())))
config.cursor.execute(sql)

Fabricator · Accepted Answer · 2014-06-23 21:52:45Z

1

do it without the WHERE statement, and quote the timestamp

sql = "UPDATE %s SET TIMESTAMP = '%s'" % (TLA_dict['TLA_name'], config.time.strftime("%Y-%m-%d %H:%M:%S", config.time.localtime(config.time.time())))

edited Jun 23, 2014 at 21:52

answered Jun 20, 2014 at 23:16

Fabricator

12.8k2 gold badges29 silver badges40 bronze badges

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

3 Comments

Fabricator Over a year ago

@user3761743, looks like your timestamp was not quoted, see updated answer

user3761743 Over a year ago

thank you! Could you please explain what the '%s' means? What is the significance of the single quotes?

Fabricator Over a year ago

In python, %s is the placeholder used in string interpolation like 'hello %s' % ('world',). The single quote is needed around the timestamp because mysql require non-numeric values to be surrounded with quotes like t = '2014-01-01 00:00:00'.

Collectives™ on Stack Overflow

python mysql update timestamp

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related