Is there any MySQL Table editor that works like microsoft excel?

I made a huge mistake in my MySQL of my site and i need to nit pick and put alot of information back. particularly i need to put back the information in about 10 fields. and there are 100s of ids. and new ids are made all the time. long story short, i need to by able to copy and paste info easily. anyone know of any type of software?

 

Doesnt exist, not the quick copy and paste stuff at least. If this is something that is uniform throughout your database, you might consider just writing a script that checks for a few variables that determine if it should be moved or not, and then they do it once decided (if you understand what I just said)

Short Answer, I know of none, but would like to see one as well

 

Sounds like something a well-built UPDATE should be able to do. Use the database's own logic.

 

There's no table editor that'll let you copy and paste like excel. That goes for any database system, mysql/oracle/sql server/etc.

 

You could export as CSV or whatever, import it into excel, play with it then try and import it back in. Bit of hassle, though.

 

You can use Excel with ODBC. You need an ODBC driver for MySQL. In this case, you can edit DIRECTLY your tables, without exporting/importing using csv.