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, 1791🔥, 0💬
Popular Posts:
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...
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 UFT (Unified Functional Testing) tool? I want to know how to use UFT. Her...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to find out my browser's identification information? To help you to see your browser identificat...