Collections:
Modify MySQL Table to Store New Field
How to Modify the MySQL Table to Store New Fields? I have just added "testID" to the test result file.
✍: FYIcenter.com
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 Execution Identification to Test Result
⇐ Add Custom Field to JMeter Test Result
2017-10-16, 1920🔥, 0💬
Popular Posts:
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...
How to Pass Windows Environment Variable to JMeter? I want to use Windows temporary folder environme...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...