Jump to content


Photo

Help with PHPMyAdmin


  • Please log in to reply
6 replies to this topic

#1 simcoweb

simcoweb
  • Members
  • PipPipPip
  • Advanced Member
  • 1,102 posts
  • LocationCA

Posted 11 June 2003 - 11:45 PM

Hi all. This is a simple question. But, as we all know, if you don\'t have the answers then it\'s not so simple ;)

I\'m new to MySQL databases and i\'m using PHPMyadmin to administrate a shopping cart database. I\'m not that familiar with the interface and there\'s absolutely no tutorial type instruction with the program.

Here\'s the scoop:

I need to remove the data from one field of one of the tables. There\'s 1850 products in the database. When I first log in i\'m presented with the various tables on the left. I select \'Products\'. Then that displays all the fields in that particular table. One of them is:

product_shipemail

I need to remove the entries from that field. NOT the field itself.

I\'m presented with the following choices and looking at this list of fields with a checkbox next to it:

Browse
Select
Insert
Empty
Drop

The reason i\'m paranoid is simple. I haven\'t a clue if any of these commands (not Browse or Select) will just wipe out the entire database, or, just the field I selected, or, the entire table i\'m viewing, or, etc. etc. etc. and there\'s not indication before I click it if it\'s a one-click command, warns me 12 times, says a prayer, or what.

So before my shaking hand accidentally deletes literally days worth of work, I wanted to see if I could get a little guidance on this.

Thanks!

#2 Jeff23

Jeff23
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 12 June 2003 - 02:29 AM

I think that the easiest way (well the way I do it) is to go to browse. Then, you scroll down through your entries until you come across the one that you want deleted. On the left hand side there will be the command \'edit\' and \'delete\'. Just push the delete one on the left of the row you want deleted and it will remove only that row.

#3 simcoweb

simcoweb
  • Members
  • PipPipPip
  • Advanced Member
  • 1,102 posts
  • LocationCA

Posted 12 June 2003 - 02:36 AM

Thanks for the post!

What you\'ve described is for deleting an entry. If you can visualize this, you\'ve mentioned deleting a \'row\' (or editing). I want to delete the content in a \'column\'.

To further clarify, there are approximate 1860 products (rows) and 27 fields (columns). I want to delete the information in field #27 for all 1860 products.

#4 Jeff23

Jeff23
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 14 June 2003 - 02:03 AM

Ahh, I see. I\'m sure you\'ve probably got this from someone else already, but here goes. Under the \'structure\' section, you should just be able to put a check next to the field that you don\'t want anymore and go to the with selected and push \'drop\' which is right next to \'change\'. It will get rid of that field for you.

#5 simcoweb

simcoweb
  • Members
  • PipPipPip
  • Advanced Member
  • 1,102 posts
  • LocationCA

Posted 14 June 2003 - 06:34 AM

Thanks! But we did successfully get this taken care of. :)

#6 mixmaster

mixmaster
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 June 2003 - 07:12 PM

please share with us how you took care of it?

#7 simcoweb

simcoweb
  • Members
  • PipPipPip
  • Advanced Member
  • 1,102 posts
  • LocationCA

Posted 29 June 2003 - 07:30 PM

We ran this query and it removed everything from that particular field:

UPDATE table_name SET product_shipemail=\'\'

(replace \'table_name\' with the actual name)

We wanted to remove the data in the \'product_shipemail\' and leave it blank. If we placed text in between the two \' \' marks then it would\'ve replaced what was there with the new stuff.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users