title: How could I update my data dynamically from MySQL with logstash (without duplicate)?
body: <p>I have configured logstash.conf to insert dynamically the data of my database but the issue is : </p>
  
  <p>when I change a line of my table that line is not updated in my index because I only insert new values after sql_last_value, I though about us a trigger but I don't sure how can I do it. </p>
  
  <pre><code>input {
    jdbc { 
      jdbc_connection_string =&gt;"jdbc:mysql://localhost:3306/blog"
      jdbc_user =&gt;"root"
      jdbc_password =&gt;""
      jdbc_driver_library =&gt;"C:\Users\saidb\Downloads\mysql-connector-java-5.1.47\mysql-connector-java-5.1.47.jar"
      jdbc_driver_class =&gt;"com.mysql.jdbc.Driver"
      schedule =&gt;"* * * * *"
      statement =&gt;"SELECT * FROM blog_pro WHERE id &gt;:sql_last_value"
      use_column_value =&gt;true
      tracking_column =&gt;id
      }
    }
  output {
    elasticsearch {
      hosts =&gt;"localhost:9200"
      index =&gt;"blog_pro"
      document_type =&gt;"data"
    }
  }
  </code></pre>