How to insert extract datatable to mysql database

[Chethan_P]

how to insert extract data from the Flipkart and I want to insert data to MySQL database
can anyone tell how to insert.
database connected to my SQL but it not insert
please help me

I get an error : –

How to write quire???

[supermanPunch (Arpan)]

@Chethan_P We would have to see the query that you have used, and also maybe Screenshots of how you have implemented it is helpful.

[Chethan_P]

[Pratik_Wavhal]

Hi @Chethan_P

Below is the thread for data extraction from flipcart (Example) :-

Data Scraping from website to excel

Hi @Jyotsnarani So i have prepared the complete workflow which fulfils all your requirement. Below is the working attached workflow files. Practise Solutions for Forum.zip (848.2 KB) Hope this may help to solve your query Definetly mark as solution & like it. Happy Automation Best Regards Er Pratik Wavhal

Below is the query you have to use to Insert Data into SQL Database :-

"INSERT INTO iphonedata.iphonedatai VALUES ('"+Name+"','"+url+"','"+Prize+"','"+From+"','"+InrShipping+"')"

Note :- Use the query in Assign Activity

Even though you wont write the column name in the SQL Query then also it is ok
Just put the variables in the sequence as per the database table is created in the MySQL

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[supermanPunch (Arpan)]

@Chethan_P

@Chethan_P I am not sure why you have used the query in that way. The Syntax normally would be in this form :

INSERT INTO table_name (column1, column2, column3, …)
VALUES (value1, value2, value3, …);

Hence, in your case I think the query should be the below :

Try this and let us know if any error occurs.

[Chethan_P]

@supermanPunch

i Use this quire i gt error

[supermanPunch (Arpan)]

@Chethan_P Can you show me the query you have used ?

[Chethan_P]

Actully i change some value in data table
i get error like this now

And This is the

This is quires

[supermanPunch (Arpan)]

@Chethan_P

image1366×768 112 KB

@Chethan_P I would guess that should be due to a max length problem, since you have provided the Column Types as varchar(45). You would have to Edit the Database table and make the Column Types From varchar(45) to varchar(max) if you want to store variable character length in it.

[Pratik_Wavhal]

Hi @Chethan_P

1st Thing is the one @supermanPunch told along with varchar(Max) also try using nvarchar and even though if it wont work then

Below is the query you have to use to Insert Data into SQL Database :-

"INSERT INTO iphonedatai VALUES ('"+Name+"','"+url+"','"+Country+"','"+Prize+"')"

Note :- Use the query in Assign Activity

Even though you wont write the column name in the SQL Query then also it is ok
Just put the variables in the sequence as per the database table is created in the MySQL

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Chethan_P]

How to use the query in assine activity

[Pratik_Wavhal]

Hi @Chethan_P

See below img, This is the way to do it :-

Note :- The variable in which you are going to Store the query within Assign Activity will be of String Type

Happy Automation

Best Regards
Er Pratik Wavhal

[Chethan_P]

Thank you its also working I want to know why we want to use in assign activity we can use directly in executing non-query.

[Pratik_Wavhal]

Hi @Chethan_P

Yes. Its not the thing that every time we have to write it within Assign Activity.

Directly we can write the query in Execute Non Query Activity also.

But just for specifying that if you are doing some multiple operations so multiple queries might der so for identifying uniquely with the variable name i suggest to use Assign Activity

Happy Automation

Best Regards
Er Pratik Wavhal

[Chethan_P]

yes your right thank you for KT