import mysql data to a table, edit/clone rows, and insert new rows

Question

Is there already any software that will allow me to select a table or row from existing DB, edit that table, add new rows, or clone existing ones, then insert the new rows back into the DB?

Read: i want to ADD this data, do not want to update/replace existing data.

PHP5, and MySQL 5

Answer 1

There's PHPMyAdmin, which will let you to pretty much anything to a database.

You can clone rows by editing and selecting "insert as new row" (may have to blank out the primary key if you have one).

Answer 2

MySQL Administrator is a decent GUI put out by MySQL that should handle all of that. I'm quite happy with it.

Answer 3

There's also HeidiSQL which is a windows client for managing MySQL databases: http://www.heidisql.com/

And there's jHeidi from the same site that's java based and so should run on other operating systems.