mySQL table editing question? - GoFuckYourself.com

Danielle · 10-13-2006, 10:09 PM

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 · 10-13-2006, 10:11 PM

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 · 10-13-2006, 10:16 PM

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

Danielle · 10-13-2006, 10:51 PM

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

Maybe exporting will work better. hmmmmm....

Hugs,
Danielle

Adultnet · 10-14-2006, 12:41 AM

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

bl4h · 10-14-2006, 12:43 AM

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

teksonline · 10-14-2006, 12:45 AM

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 · 10-14-2006, 12:47 AM

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

3M TA3 · 10-14-2006, 12:51 AM

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 · 10-14-2006, 01:12 AM

Quote:

Originally Posted by bl4h

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 · 10-14-2006, 01:15 AM

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 · 10-14-2006, 01:32 AM

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 · 10-14-2006, 01:35 AM

Quote:

Originally Posted by 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

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 · 10-14-2006, 01:41 AM

Quote:

Originally Posted by fetishblog

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

Great tool... Im sure this can do

teksonline · 10-14-2006, 01:44 AM

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

bl4h · 10-14-2006, 02:00 AM

Quote:

Originally Posted by Danielle

Because I want to.

Hugs,
Danielle

dissipate · 10-14-2006, 02:05 AM

Quote:

Originally Posted by toonpornblog

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

Gosh, you're retarded.

Danielle · 10-14-2006, 02:25 AM

Quote:

Originally Posted by teksonline

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 · 10-14-2006, 02:31 AM

Hugs, Danielle?

Danielle · 10-14-2006, 08:49 PM

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

Hugs,
Danielle

BitAudioVideo · 10-14-2006, 08:54 PM

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

Adultnet · 10-14-2006, 08:55 PM

Quote:

Originally Posted by Danielle

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 · 10-14-2006, 08:55 PM

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 · 10-14-2006, 08:56 PM

Quote:

Originally Posted by 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 · 10-14-2006, 09:31 PM

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 · 10-14-2006, 09:34 PM

Quote:

Originally Posted by toonpornblog

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 · 10-14-2006, 09:59 PM

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.

10-13-2006, 10:09 PM	#1
Danielle Confirmed User Join Date: Jun 2002 Location: My Coffin Posts: 1,227	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

10-13-2006, 10:11 PM	#2
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	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. __________________ AIM: GrouchyGfy

10-13-2006, 10:16 PM	#3
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	Dammit. Here's the homepage. Dunno why I did .org. I blame stupidity. __________________ AIM: GrouchyGfy

10-14-2006, 12:41 AM	#5
Adultnet Confirmed User Join Date: Sep 2003 Posts: 8,713	try tucows im sure you will find a nice and free mysql editor __________________ TrafficCashGold Paying Webmasters Since 1996! Awesome Conversions! Fast Weekly Payments! Over 125 Tours!

10-14-2006, 12:47 AM	#8
fetishblog Confirmed User Join Date: Sep 2005 Location: Your mom is my favorite pornstar!#% Posts: 5,995	http://www.mysql.com/products/tools/administrator/ __________________ Fling.com doesn't steal your traffic and sales unlike some other dating companies. I promote them, and so should you!

10-13-2006, 10:51 PM	#4
Danielle Confirmed User Join Date: Jun 2002 Location: My Coffin Posts: 1,227	Thanks toonpornblog. I use phpmyadmin but it makes you edit one record at a time. Maybe exporting will work better. hmmmmm.... Hugs, Danielle

10-14-2006, 12:43 AM	#6
bl4h Confirmed User Join Date: Jul 2006 Location: Philadelphia Posts: 1,282	why would you need to do that. this is what myslq is all about. Editing entire database with single command

10-14-2006, 12:45 AM	#7
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	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

10-14-2006, 12:51 AM	#9
3M TA3 Confirmed User Join Date: Aug 2005 Location: So Cal Posts: 2,972	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. __________________ Dedicated and colo hosting: ICQ 291313057 "A problem cannot be solved from the same consciousness that created it. We must learn to see the world anew." - Albert Einstein

10-14-2006, 01:15 AM	#11
Danielle Confirmed User Join Date: Jun 2002 Location: My Coffin Posts: 1,227	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

10-14-2006, 01:32 AM	#12
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	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

10-14-2006, 01:44 AM	#15
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	I think what you're looking for is a magic wand

10-14-2006, 02:31 AM	#19
V_RocKs Damn Right I Kiss Ass! Industry Role: Join Date: Dec 2003 Location: Cowtown, USA Posts: 32,428	Hugs, Danielle?

10-14-2006, 08:49 PM	#20
Danielle Confirmed User Join Date: Jun 2002 Location: My Coffin Posts: 1,227	bump. Anyone know of a script that will do this? Hugs, Danielle

10-14-2006, 08:54 PM	#21
BitAudioVideo Confirmed User Join Date: Jul 2005 Location: USA, Georgia Posts: 1,246	you could probably find a programmer to write up a simple php script to do this in about 10 minutes __________________ Hi-Quality Encoding - Bulk Orders - On Time! http://bitaudiovideo.com icq 50476697 - aim n3r0xXx

10-14-2006, 08:55 PM	#23
fusionx Confirmed User Industry Role: Join Date: Nov 2003 Location: Olongapo City, Philippines Posts: 4,618	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.

10-14-2006, 09:31 PM	#25
Danielle Confirmed User Join Date: Jun 2002 Location: My Coffin Posts: 1,227	Thanks Adultnet and fusionx! That looks like what I am looking for. Going to go download it and give it a try. Hugs, Danielle

10-14-2006, 09:59 PM	#27
Damian_Maxcash So Fucking Banned Join Date: Oct 2002 Location: MaxCash.com Posts: 12,745	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.