A way to quickly populate a database (mysql)?

Question

MySQL

Maybe there is something like this in PHPStorm?
There is a database with huge tables, and they are all empty, but I have to work with the search, and it takes too long to fill each table, is there a way to speed this up?

Answer 1

www.generatedata.com fill in the table with the required fields, get an array in the required PL (or csv) and upload it in one go.

Answer 2

if there is data in CSV, then pay attention to LOAD DATA INFILE