tags:

views:

124

answers:

3

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

+1  A: 

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).

Greg
phpmyadmin is a little too technical for my user's purposes. Since i only want to allow them to ADD
Patrick
@Patrick - if you have user-based permissions on the database, when they login to PHPMyAdmin, they'll only be able to do what their user's allowed to do :) ..though I do agree that it's probably overkill for what you're looking at, it can be setup to handle it ;)
warren
A: 

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

zombat
need this to be webbased, thanks tho
Patrick
You should edit your question to mention that. I'll leave this answer here just for the sake of people who find this thread later.
zombat
A: 

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.

Vex