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, 1742🔥, 0💬
Popular Posts:
Where to find tutorials on Test Management? I want to know how to manage software testing documents ...
How to set Content-Type to application/json? The server requires the Content-Type to be application/...
How to access Response Status Code 400 as Success? My sampler failed, because the server returns the...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...