MySQL_Connector_Arduino icon indicating copy to clipboard operation
MySQL_Connector_Arduino copied to clipboard

Possiblity to extend for delete and update

Open JoeyUson opened this issue 2 years ago • 0 comments

I noticed that insertion and show variable such as show database are included in demo. I tried to use delete and update but it give an error.

Any recommendation for below quierries

  1. "UPDATE testdbs.testtable SET message = Goodbye WHERE counter=1000 give error (testdbs is database testtable is table inside the database with counter set as autoincrement.
  2. "DELETE from testdbs.testtable where counter=1000.

Note: assuming the database and table are populated with these values already

Final comment: Delete and Update tested and working fine with esp8266 both local and web hosted database. Thanks it will help me develop of centralize login/logout

JoeyUson avatar Jul 03 '22 08:07 JoeyUson