有什么方法可以“乘以”MySql记录来测试服务器上的大型数据库？

Question

I have several mysql tables in a database.

Currently I am doing finishing test on my website, and one is to test a heavy db to see how much this affects performance (searching).

The website is a classifieds website. It would take a very long time for me to insert one classified at a time to reach a significant nr.

So I wonder, is there any way of multiplying records in MySql, preferrably with phpMyAdmin?

Lets say I already have 20 finished records, and just multiply them several times and I get a large db in no time. Possible?

You should know that my tables have foreign keys and other relations...

If you need more input let me know...

Thanks

Answer 1

insert into mytable ( col1, col2, col3... )
select col1, col2, col3 from mytable