Python MYSQL update statement

by

It should be:

cursor.execute ("""
   UPDATE tblTableName
   SET Year=%s, Month=%s, Day=%s, Hour=%s, Minute=%s
   WHERE Server=%s
""", (Year, Month, Day, Hour, Minute, ServerID))

You can also do it with basic string manipulation,

cursor.execute ("UPDATE tblTableName SET Year=%s, Month=%s, Day=%s, Hour=%s, Minute=%s WHERE Server="%s" " % (Year, Month, Day, Hour, Minute, ServerID))

but this way is discouraged because it leaves you open for SQL Injection. As it’s so easy (and similar) to do it the right waytm. Do it correctly.

The only thing you should be careful, is that some database backends don’t follow the same convention for string replacement (SQLite comes to mind).

More Related Contents:

  1. Installing specific package version with pip
  2. Database does not update automatically with MySQL and Python
  3. mysql-python install error: Cannot open include file ‘config-win.h’
  4. How to insert pandas dataframe via mysqldb into database?
  5. Install mysql-python (Windows)
  6. When to close cursors using MySQLdb
  7. Python 3.4.0 with MySQL database
  8. How can I use executemany to insert into MySQL a list of dictionaries in Python
  9. MySQL: Get column name or alias from query
  10. ImportError: No module named MySQLdb
  11. Print the actual query MySQLdb runs?
  12. Can’t install mysql-python (newer versions) in Windows
  13. Dynamic SQL Queries with Python and mySQL
  14. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  15. How to use python mysqldb to insert many rows at once
  16. ‘pip install MySQL-python’ fails with ‘IndexError’
  17. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  18. How to disable query cache with mysql.connector
  19. MySQL parameterized queries
  20. PyInstaller, spec file, ImportError: No module named ‘blah’
  21. Load CSV data into MySQL in Python
  22. Enable Python to Connect to MySQL via SSH Tunnelling
  23. How to replace Django’s primary key with a different integer that is unique for that table
  24. Installing mysqlclient in Python 3.6 in windows
  25. Python Pandas write to sql with NaN values
  26. Python: use mysqldb to import a MySQL table as a dictionary?
  27. InterfaceError (0, ”)
  28. Remove duplicates in list of object with Python
  29. Print results in MySQL format with Python
  30. flask-login: can’t understand how it works

Leave a Comment