Python MySQL Error 1064 inserting datetime string

Question

I have the following python code:

now = time.strftime('%Y-%m-%d %H:%M:%S')
#now = datetime.datetime.now()
query = """INSERT INTO bandwidth_by_second (current_time, down, up)  VALUES (%s, %s, %s)"""
data = (now, 1.0, 2.0)
cursor.execute(query, data)

My schema for this table is:

current_time - datatime
down - double
up - double

When running this, I get the following error:

_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_time, down, up) VALUES ('2014-10-27 18:29:32', 1, 1)' at line 1")

I had thought I had formatted the date time wrong, but this post suggests otherwise.

What the heck is going on?

Shabir A. · Accepted Answer · 2014-10-27 17:33:09Z

3

Use '%s' in quotes. It will work then :)

answered Oct 27, 2014 at 17:33

Shabir A.

3061 silver badge10 bronze badges

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

1 Comment

JSK NS Over a year ago

I see other answers that suggest the same thing. When I do that query = """INSERT INTO bandwidth_by_second (current_time, down, up) VALUES ('%s', %s, %s)""", the resultant error looks like

(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_time, down, up)  VALUES (''2014-10-28 08:11:52.306849'', 1, 1)' at line 1")

JSK NS · Accepted Answer · 2014-10-28 07:44:21Z

1

It had to do with the column name in the database table. I changed current_timeto currenttime and it started working.

answered Oct 28, 2014 at 7:44

JSK NS

3,4542 gold badges30 silver badges42 bronze badges

1 Comment

William Papsco Over a year ago

You are a god to me. I just spent several hours trying to figure this out. Thank you so much!

Collectives™ on Stack Overflow

Python MySQL Error 1064 inserting datetime string

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related