mySQL table editing question?
 

Anyone know of a script that will load a mySQL table into a spreadsheet view and then allow you to edit all spreadsheet cells and then save the entire table?

Hugs,
Danielle

Not as a spreadsheet, but most people do this with PhpMyAdmin.

Honestly, if you just want to do an edit, do a dump, then use your favorite text editor? I suppose you could export it as a CSV type, but that's going to cause issues.

Dammit. Here's the homepage. Dunno why I did .org. I blame stupidity.

Thanks toonpornblog. I use phpmyadmin but it makes you edit one record at a time.

Maybe exporting will work better. hmmmmm....

Hugs,
Danielle

try tucows im sure you will find a nice and free mysql editor :)

why would you need to do that. this is what myslq is all about. Editing entire database with single command

what field are you changing as are they unique? php is a web interface to mysql client, you execute queriues to do bulk changes

<column> has 50004239492942 rows containing <column> = 1
UPDATE <table> SET <column>='5' WHERE <column>='1';
whee all done

hmm, you can always export the entire database in CSV which will be easy to import into excel, however, returning it to mysql will be a little tougher than exporting it.

phpmyadmin will let you mass update multiple tables with a single command and there are a lot of intuitive shortcuts in it.

just don't forget to back up you db before you start playing.

Because I want to. :)

Hugs,
Danielle

I think I should better describe what I want to do......

I have a table with the following fields.

field 1, field 2, field 3, field 4

I want to view all of the table in a spreadsheet view and be able to edit all the records and fields like you can in Excel. Then save the entire table back.

Hugs,
Danielle

you need database experience or a database admin to do these tasks for you, its a simple but multi-step proccess

connect to mysql client.. if you have shell access to server you can do something like

echo "SELECT field1, field2, field3, field4 FROM <tablename>"|mysql -u<username> -p <databasename> >filename.txt

this will put all those records into filename.txt, then load into spreadsheet selecting proper formatting, might be a space or tab, between fields, i forget
offhand

you need to include the primary key field in your selects so when your done you can use the following commands to re-import

UPDATE <tablename> SET field2 = 'blah', field3 = 'blah' field4='blah' WHERE field1 = 'ID'; based off a written script of some sort that is reading the text file line by line

To much of a pain in the ass way to do it. :) That is why I am looking for a script that can do what I want.

Hugs,
Danielle

Great tool... Im sure this can do :thumbsup

I think what you're looking for is a magic wand

Gosh, you're retarded.

Nope.... Just a way to edit a mySQL table in a spreadsheet view.

Hugs,
Danielle

Hugs, Danielle?

bump. Anyone know of a script that will do this?

Hugs,
Danielle

you could probably find a programmer to write up a simple php script to do this in about 10 minutes

Danielle, you got a good software for this allready posted inisde this topic..
http://www.mysql.com/products/tools/query-browser/

MySQL Tools Query browser

Connect to the DB

Run a query "select * from tablename"

Edit whatever you want to edit

Click Apply Changes at the bottom

Done.

comes with a demo...
http://www.mysql.com/products/tools/...edit_rows.html

Thanks Adultnet and fusionx!

That looks like what I am looking for. Going to go download it and give it a try.

Hugs,
Danielle

I tried that once and had problems, but I thought it was just me.

Have a look at http://navicat.com/

Its a windows prog that hooks into your MySql server and allows to edit tables etc.

Its so much easier than phpmyadmin - when importing large dumps it always times out ect - you can use this and it runs like clock work.

I use it for everything.