search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
332 stars 133 forks source link

Possiblity to extend for delete and update #189

Open JoeyUson opened 2 years ago

JoeyUson commented 2 years ago

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