def UpdateCustomerOrderInfo(db,cursor): cursor.execute (""" UPDATE customerorder SET CustomerID=%s, DelDate=%s, DelTime=%s, TotalCost=%s HAVING OrderID=%s """, (CustomerID, DelDate, DelTime, TotalCost, OrderID))
rs.ProgrammingError: 1064 (42000): 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 'HAVING OrderID='423'' at line 3
|PHP - modify class to use temporary MySQL table?||15||53|
|Optimum versions of Selenium Webdriver with Python On Windows 7||1||80|
|SQL, Updating Statistics take too long for 60GB database||5||103|
|how to split multiple lines delimiter :||8||78|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
27 Experts available now in Live!