Collections:
Truncate Test Case and Test Run Tables
How to Truncate Test Case and Test Run Tables? I want to remove old data and start it over from empty tables.
✍: FYIcenter.com
You can follow this tutorials to truncate Test Case and Test Run Tables.
1. Create a SQL script file, TruncateTestMan.sql:
-- TruncateTestMan.sql use TestMan; truncate table Test_Run_Case_Step_Input; truncate table Test_Run_Case_Step_Assertion; truncate table Test_Run_Case_Step; truncate table Test_Run_Case_Parameter; truncate table Test_Run_Case; truncate table Test_Run; truncate table Test_Case_Step_Input; truncate table Test_Case_Step_Assertion; truncate table Test_Case_Step; truncate table Test_Case_Reference; truncate table Test_Case_History; truncate table Test_Case_Parameter; truncate table Test_Case;
2. Run TruncateTestMan.sql:
>\fyicenter\mysql\bin\mysql -u fyicenter < TruncateTestMan.sql
⇒ Generating Reports from TestMan Database
⇐ Archive JMeter Test Result Data
2017-11-26, 2371🔥, 0💬
Popular Posts:
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to Open and Close Internet Explorer with UFT script? One way to open and close Internet Explorer...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to find out my browser's identification information? To help you to see your browser identificat...