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, 1720🔥, 0💬
Popular Posts:
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...
How to generate date and time test values? Timestamp values are frequently needed in testing almost ...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to Pass Windows Environment Variable to JMeter? I want to use Windows temporary folder environme...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...