Copy MYSQL Rows Quickly


Populate MYSQL Database

Intention: To populate a mysql database table very quickly by copying existing rows and adding them to the existing rows.

To populate a table quickly for testing purposes,
1) open phpmyadmin
2) Select export(but do not make a file) >go
3) Copy the insert into statement.
4) Open desired table
5) SElect SQL
6) Paste Insert into statement into the text area >Alter entries if desired (especially any auto increment field) >go