Working on mysql workbench

Help Activities
, ,
1

i am on excel UiPath and mysql workbench.
with the help of UiPath i am opening mysql. i want to write query into mysql.
i have an excel sheet in which column A has multiple names. i want to put that name in my query. How can i do it.

i read the excel file and save into data table… for each row of column “A” i want to put it as

select * from “PAM Pvt.”;
select * from “PQR pvt.”;

these “PAM pvt” and “PQR pvt” are available in excel’s column A.
i have 500+ entries that i need to find.
please help in this.

i Don’t want to connect my bd in UiPath.

2

Hi @office_work

Please try this


Read Excel Data (output to DataTable)
For Each Row in DataTable
    SQL Query = "select * from `" & row("ColumnName").ToString() & "`"
    Write Line: SQL Query
3

@office_work

can you explain in detail about your requirement

cheers

4

image
i am getting this error

5

i have an excel file where in column “Name” contain multiple values in each row
from where i want to select the string and take into my Query in mysql.

Such as
select * from “RAM”;
select * from “Raj”;
select * form “Jack”;
these name are there in rows of column “name”.

6

Try this @office_work

“select * from " & CurrentRow("ColumnName").ToString() & "”

7

@office_work

try this once

string.Format(“select * from {0}”,row(“Name”).tostring)

8

image
Again error is

9

Have you tried this @office_work

10

@office_work

can you share the error screenshot

what the error it is showing