Help Center > > User Guide> MySQL Database Management (Standard Edition)> Data Plan> Generating Test Data

Generating Test Data

Updated at: Mar 20, 2020 GMT+08:00


During the functional testing of a program, a large amount of test data needs to be inserted into the database, and the generated test data should comply with specific rules. DAS allows you to create automated test data generation tasks based on specific rules, making your test data generation efficient.


You have logged in to the DAS console.

  1. On the top menu bar, click Data Plan and choose Generate Test Data.
  2. On the displayed page, click Create Task. In the displayed dialog box, specify the required parameters and click OK.

    • Generated rows

      The maximum number of generated rows is 1,000,000.

    • Conflict

      If you select Ignore, the system skips the row that contains the conflicts and continues processing subsequent rows. If you select Replace, the system deletes the rows that are causing the conflicts prior to inserting data. If a conflict occurs when a row with the same primary key value is inserted, the original rule will be replaced.

    • Generation type
    • You can set the rules for randomly generated data based on the column settings. For example, if the column type is time, you can set the start time, end time, and format, or set the value to the current time.

  3. After setting the task information, click Preview to check whether the generated data is as expected and then adjust the settings. You can also click Generate to obtain the test data.
  4. In the task list, view details about the generated tasks in the table. You can also delete the task as required.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel