How to Modify the MySQL Table to Store New Fields? I have just added "testID" to the test result file.

You can follow this tutorial to modify the MySQL table to store the new field.

1. Run MySQL client tool and with this command:

mysql> alter table jmeter_test_result add column testID INT;

2. Run JMeter and run "\fyicenter\First-Load-Test-6.jmx" again.

3. Run MySQL client tool and with this command:

mysql> select testID, from_unixtime(timeStamp/1000) as time, 
   elapsed, label, success 
   from jmeter_test_result order by timeStamp desc limit 0,10;
   
+--------+--------------------------+---------+----------+---------+
| testID | time                     | elapsed | label    | success |
+--------+--------------------------+---------+----------+---------+
|    123 | 2017-11-17 22:40:20.9240 |      42 | Google   | true    |
|    123 | 2017-11-17 22:40:20.8820 |      41 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.8390 |      43 | Google   | true    |
|    123 | 2017-11-17 22:40:20.7940 |      44 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.7500 |      42 | Google   | true    |
|    123 | 2017-11-17 22:40:20.7250 |      46 | Google   | true    |
|    123 | 2017-11-17 22:40:20.7060 |      44 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.6830 |      42 | Facebook | true    |
|    123 | 2017-11-17 22:40:20.6580 |      47 | Google   | true    |
|    123 | 2017-11-17 22:40:20.6410 |      41 | Google   | true    |
+--------+--------------------------+---------+----------+---------+

 

⇒ Add Excution Identification to Test Result

⇐ Add Custom Field to JMeter Test Result

⇑ Saving Test Results to MySQL Database

⇑⇑ Apache JMeter Tutorials