Latest News: (loading..)

TracyS

Member Since 09 Oct 2006
Offline Last Active Jun 20 2011, 19:39

Find content

Community Stats

Group Community Member
Active Posts 1,194 (0.58 per day)
Most Active In General Add-Ons Support (847 posts)
Profile Views 14,518
Age 40 years old
Birthday September 15, 1971
Real Name
Tracy
Gender
Female
Location
U.S.

Contact Information

2 Neutral

Friends

Latest Visitors

spc456
25 Mar 2012, 05:49
kurt1
15 Sep 2011, 18:01
Peper
06 Jul 2011, 12:34
PupStar
20 Jun 2011, 20:49
here2learn
06 May 2011, 03:59

Topics I've Started

Deleting Data from Rows within a Table

20 June 2011, 19:23

Does anyone have a fairly simple method for deleting the data within certain rows of a table without deleting the rows or the table? I have tried Truncate, but that takes everything out of all of the rows within the table, not just the rows I have selected (phpMyAdmin).

We moved our site, but want access to our stats from the old one, so I want to pull addresses and other private info out of the database, while still leaving the orders and such in tact for reports. So far, all I can see for doing this, is manually going through and deleting the info off of each record in the orders table. There has to be an easier way to delete the info in specific rows while leaving the rest of the table in-tact?? :blush:

Thanks in Advance!