Generate insert statement from table data, mysql syntax - http://mahmoudoracle.blogspot.com.au/2012/07/create-insert-statement-for-table-data.html

Or with random number - http://moinne.com/blog/ronald/mysql/howto-generate-meaningful-test-data-using-a-mysql-function