the Delete(mySQL Network) seems to produce the wrong query. (Is not doing anything).
I’m connected to a database and all ohter nodes (Insert, Select, Update) work fine.
I want to delete a row from a table called “sound” where “length = 10s”.
The node produces the statement:
DELETE sound WHERE length = ‘10s’
Shouldn’t this be:
DELETE FROM sound WHERE length = ‘10s’
The status says:
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 ‘WHERE length = ‘10s’’ at line 1