statement => "SELECT id, mycolumn1, mycolumn2 FROM my_table WHERE id > :sql_last_value"

tracking_column => id

use_column_value => true

input {
  jdbc {
  jdbc_driver_library => "mysql-connector-java-5.1.36-bin.jar"
  jdbc_driver_class => "com.mysql.jdbc.Driver"
  jdbc_connection_string => "jdbc:mysql://localhost:3306/database"
  jdbc_user => "DBUSERNAME"
  jdbc_password => "DBPASSWORD"
  statement => "select * from TABLE where id >:sql_last_value"
  tracking_column => id
  use_column_value => true
  #I have scheduled this to run in every second
  schedule => "* * * * * *"
  }
}
output {
  elasticsearch {
    hosts => "localhost:9200"
    index => "index"
    document_type => "type"
    user => "userName"
    password => "password"
  }
  stdout {
    codec => rubydebug
  }
}