# Jdbc update and delete
**URL:** https://discuss.elastic.co/t/jdbc-update-and-delete/74595
**Category:** Logstash
**Created:** [February 10, 2017, 4:36am UTC](https://discuss.elastic.co/t/jdbc-update-and-delete/74595 "2017-02-10T04:36:21Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Greentea](https://discuss.elastic.co/u/Greentea)
#### Post date: [February 10, 2017, 4:36am UTC](https://discuss.elastic.co/t/jdbc-update-and-delete/74595/1 "2017-02-10T04:36:21Z")
Hi
I am currently using logstash-plugin-jdbc to pull data from mysql to elasticsearch. I want to know is it possible to update or delete a single document in elasticsearch by modifying mysql?
For example, I got 1000 row in mysql table, and I modify no.349 row, I just want to update no.349 in elasticsearch, which is not passing the 1000 row again.
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [February 12, 2017, 6:24pm UTC](https://discuss.elastic.co/t/jdbc-update-and-delete/74595/2 "2017-02-12T18:24:58Z")
Detecting row deletions is hard, but updated rows can be picked up if you have a "last modified" column that you can include in your query so that only rows modified since the last run are updated.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 12, 2017, 6:25pm UTC](https://discuss.elastic.co/t/jdbc-update-and-delete/74595/3 "2017-03-12T18:25:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.