how to insert data in mysql from scrapy

[Anurag Sharma]

i have attached my all code
i am not able to insert data from scrapy to mysql
after attached code i am running following command

scrapy crawl amazon

please help me
how can we insert

thansk

[Danilo Oliveira]

simple google request bring it to us:

https://github.com/darkrho/dirbot-mysql

[Anish Pradhan]

I had same problem and I solved the problem with pipeline. I used mysqldb to insert the data directly to mysql. 

[Anurag Sharma]

thanks for reply 

i tried with pipeline it 's done

i need without pipeline 

i am trying without pipeline but it saved last record in DB 

is there any way to define pipeline belongs to specific spider

thanks

--
You received this message because you are subscribed to a topic in the Google Groups "scrapy-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/scrapy-users/KmWOp4Vns-k/unsubscribe.
To unsubscribe from this group and all its topics, send an email to scrapy-users...@googlegroups.com.
To post to this group, send email to scrapy...@googlegroups.com.
Visit this group at http://groups.google.com/group/scrapy-users.
For more options, visit https://groups.google.com/d/optout.

--

Thanks
anurag sharma