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 Excution Identification to Test Result
⇠Add Custom Field to JMeter Test Result
⇑ Saving Test Results to MySQL Database
⇑⇑ Apache JMeter Tutorials
2017-10-16, 1522👍, 0💬
Popular Posts:
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...