JMeter iterating through the data in a database table

1. Create a JDBC Request first

2. Request to add a loop controller after the result tree is correct, cycle times define the number of database table queries

   Variables names is set to Col, the following variables will be set to:

   col_#=2 (total number of rows)
   col_1= 1th column, line 1th
   col_2= 1th column, line 2nd

3. Add a counter to sit the variable stitching
   

4. Add request reference N, using function helper

5. View Results
   1. JDBC Run result

   2. View the results of a loop read

JMeter iterating through the data in a database table