writer:mySQL ,delete records, add records
2 years 6 months ago - 2 years 6 months ago #23280
by prashant
Hi Mike,
I am little stuck now , help would be appreciated .
1 .I have defined the update id
2. I am able to 'add' new records to mySQL table
What I wish to achieve is to
1. Truncate table
2. Update Recods
What I've tried
1. if I do user SQL and update statement to below , I can run these manually , they run fine in SQL editor window but I get error in Writer window
Does this mean
1. I need to run sql script first and then do addition action?
2. My query syntax is wrong (I am pretty sure this is it)
Replied by prashant on topic writer:mySQL ,delete records, add records
Hi Mike,
I am little stuck now , help would be appreciated .
1 .I have defined the update id
2. I am able to 'add' new records to mySQL table
What I wish to achieve is to
1. Truncate table
2. Update Recods
What I've tried
1. if I do user SQL and update statement to below , I can run these manually , they run fine in SQL editor window but I get error in Writer window
Code:
TRUNCATE TABLE `vg_items`;
GO insert into `vg_items` (`id`,`OurRef`,`Item` ) values (:F1,:F2,:F3 );
GO
Code:
TRUNCATE TABLE `vg_items`;
GO
insert into `vg_items` (`id`,`OurRef`,`Item` ) values (:F1,:F2,:F3 );
GO
Does this mean
1. I need to run sql script first and then do addition action?
2. My query syntax is wrong (I am pretty sure this is it)
Last edit: 2 years 6 months ago by prashant.
Please Log in or Create an account to join the conversation.