MySQL_Connector_Arduino
MySQL_Connector_Arduino copied to clipboard
Possiblity to extend for delete and update
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
- "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.
- "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