How to use Bulk update database activity?

Help Activities
, ,
1

Can any one explain about the bulk update data in database , how to use this activity, how to update the value in database
Could you please create sample flow for this

2

Hey

please check this example

Regards

4

I check but could not find the solution i’m getting some error.
image

5

Hello @samplegsuite
Bulk Update Database is used to update the values based on a certain column like Unique ID

  • Tabel name: Mention the Table name of the database that you need to update the value.
  • Data Table: pass the excel read range data table value as DT
  • Columns use for matching rows: mention the column name needs to match with the table in data base to data table need to update

image

7

@samplegsuite , Cross Check the database table to have vale p1 in the specific column.

8

Hey

when inserting values, the value should be also into semicolons like “Name” = ‘p2’

Regards

9

image
image

Both values same but I’m getting same error

Bulk update: 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 ‘“Name”=p2, “Age”=p3 WHERE “Id”=p1’ at line 1

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.