writer:mySQL ,delete records, add records

Hi,
In Transformation Type : Delete Records is supposed to 
1. Delete all records only? 
2  Delete all records mentioned in transformation , but I need to provide the primary key/update key (if yes where to enter this)
 


I tried using user_sql but get syntax error
#42000You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'insert into `vg_items` (`id`,`OurRef`,`Item` ) values (NULL,NULL,NULL  )' at line 2



 
I tried using Delete FROM , I still got error
#42000You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'insert into `vg_items` (`id`,`OurRef`,`Item` ) values (NULL,NULL,NULL  )' at line 2

In Transformation Type : Delete Records is supposed to 
1. Delete all records only? 
2  Delete all records mentioned in transformation , but I need to provide the primary key/update key (if yes where to enter this)

Delete all records mentioned in transformation and you have to provide the primary key/update key

Please read the following article:
www.etl-tools.com/wiki/advanced-etl-proc...pdatedelete-records/
and that one
www.etl-tools.com/wiki/advanced-etl-proc...-targets/sql-script/


 

Question
insert into vg_items (`id`,`OurRef`,`Item` ) values (:F1,:F2,:F3  )
F1,F2 are the sequence in which writer is getting values FROM TRANSFORMER and this is correct ?
-
----
in mean while I get this error , I get this consistently when I try to copy from sql window
 

I have seen this problem in the past and not sure it is actually related to our software

Usually restarting the app works

Right as always , restart ELT solves this . 

 Question
insert into vg_items (`id`,`OurRef`,`Item` ) values (:F1,:F2,:F3  )
F1,F2 are the sequence in which writer is getting values FROM TRANSFORMER and this is correct ?
 

Is the above correct?