Help with PHPMyAdmin
Posted 11 June 2003 - 11:45 PM
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:
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:
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.
Posted 12 June 2003 - 02:29 AM
Posted 12 June 2003 - 02:36 AM
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.
Posted 14 June 2003 - 02:03 AM
Posted 29 June 2003 - 07:30 PM
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