# Update data from mysql to elasticsearch
**URL:** https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817
**Category:** Logstash
**Created:** [November 8, 2017, 8:19am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817 "2017-11-08T08:19:30Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Shekhar\_Pandey](https://discuss.elastic.co/u/Shekhar_Pandey)
#### Post date: [November 8, 2017, 8:19am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817/1 "2017-11-08T08:19:30Z")
There is any way to fetch only update data from mysql to elasticsearch. I am using sql\_last\_value...but it will fetch only new row which comes in mysql....
Any way if I did change any previous index row in mysql...logstash fetch it and while indexing update its' version from 1 to 2.
Thank you.
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [November 8, 2017, 9:03am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817/2 "2017-11-08T09:03:21Z")
If there's a "last modified" column in the table you can use that to determine which rows need to be updated in ES, but apart from fetching all rows all the time there's nothing much you can do.
---
### Author:  [@Shekhar\_Pandey](https://discuss.elastic.co/u/Shekhar_Pandey)
#### Post date: [November 8, 2017, 9:11am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817/3 "2017-11-08T09:11:34Z")
So Sir, there is no currently method to update bulk of rows ...who are already index ....
Thanks in advance
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [November 8, 2017, 10:16am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817/4 "2017-11-08T10:16:28Z")
Logstash has no problem doing bulk updates but it needs help finding which rows from the database have changed since the last run.
---
### Author:  [@Shekhar\_Pandey](https://discuss.elastic.co/u/Shekhar_Pandey)
#### Post date: [November 9, 2017, 6:51am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817/5 "2017-11-09T06:51:54Z")
Ok Sir. Thank you.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 7, 2017, 6:52am UTC](https://discuss.elastic.co/t/update-data-from-mysql-to-elasticsearch/106817/6 "2017-12-07T06:52:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.