MySQL delete rows in a table using Python

Question

I am using Python3 and MySQL. I have a string value in date and time format (dateS).

  import datetime
  dateS = datetime.datetime.strptime(s, '%Y-%m-%d %H:%M:%S')
  # print(dateS)                 # 2018-08-27 00:30:00

I need to delete rows in table "bts_l3_single_value_data" checking with the condition where start_time is equal to mentioned datetime.

  sql = """DELETE FROM bts_l3_single_value_data WHERE start_time = dateS"""

When I execute this I'm getting an error as " Error: (1054, "Unknown column 'dateS' in 'where clause'") " and when I print the sql statement it gives as;

 DELETE FROM bts_l3_single_value_data WHERE start_time = dateS

without converting the dateS string to datetime format.

Any help. Thanks

Đào Minh Hạt · Accepted Answer · 2019-03-06 05:09:09Z

2

You are using dateS as a string, if you want to put parameter there better use f strings

sql = f"""DELETE FROM bts_l3_single_value_data WHERE start_time = {dateS}"""

But it's better to use sql variables for more secured.

answered Mar 6, 2019 at 5:09

Đào Minh Hạt

2,92618 silver badges20 bronze badges

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

Comments

Upasana Mittal · Accepted Answer · 2019-03-06 05:19:39Z

0

use .format for inducing value like this in sql query. Below is an example for that

sql = """
         DELETE FROM from bts_l3_single_value_data where start_time ='{}'
       """.format(dateS)

answered Mar 6, 2019 at 5:19

Upasana Mittal

2,6991 gold badge17 silver badges21 bronze badges

Collectives™ on Stack Overflow

MySQL delete rows in a table using Python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related