Hello
I have a connection to MySQL and need to perform a simple exercise :
1. load data from table 1 from db to qlik sense
2. write data to table 2 from qlik sense to db
I can load data from db into qlik however when I try to write data back or just clear the table (error below) in db I get the error (screenshot attached).
The following error occurred:
QVX_UNEXPECTED_END_OF_DATA: ERROR [42000] [Qlik][MySQL] DELETE command denied to user 'xxx_xxxx'@'xx.xx.xxx.xx' for table 'NPI_STATUS_TRACK_2'
The error occurred here:
SQL DELETE FROM `npi_status`.`NPI_STATUS_TRACK_2`
When I try to write data back to MSSQL it works, but qlik sense desktop doesnt allow me to write data back to MySQL.
So basically I can load from db whatever I want but 'other direction' (from qlik to db) doesnt work.
Anyone who could help me pleeeaaaase?
