mySQL table editing question?

[Danielle]

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

[GrouchyAdmin]

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.

[GrouchyAdmin]

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

[Danielle]

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

Maybe exporting will work better. hmmmmm....

Hugs,
Danielle

[Adultnet]

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

[bl4h]

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

[teksonline]

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

[fetishblog]

http://www.mysql.com/products/tools/administrator/

[3M TA3]

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.

[Danielle]

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

Because I want to.

Hugs,
Danielle

[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

[teksonline]

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

[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

[Adultnet]

http://www.mysql.com/products/tools/administrator/

Great tool... Im sure this can do

[teksonline]

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

[bl4h]

Because I want to.

Hugs,
Danielle

[dissipate]

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

Gosh, you're retarded.

[Danielle]

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

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

Hugs,
Danielle

[V_RocKs]

Hugs, Danielle?

[Danielle]

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

Hugs,
Danielle

[BitAudioVideo]

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

[Adultnet]

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

Hugs,
Danielle

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

[fusionx]

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.

[Adultnet]

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

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

[Danielle]

Thanks Adultnet and fusionx!

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

Hugs,
Danielle

[Fizzgig]

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.

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

[Damian_Maxcash]

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.