Help me Delete CC numbers in DB

[DriWashSolutions]

Hi all,

 

Just wondering if someone could tell me what the phpMyAdmin/mySQL command is to delete the value of a given field in all the records. I need to do a global delete for my CC number field, as the entire number is being stored in the DB.

 

I'm using Linkpoint API, and don't need these numbers, and the LinkPoint Contrib developer has not helped me get rid of the numbers in the application.

 

So, I'd like to be able to do this in one fell swoop, without having to go and edit each record manually with phpMyAdmin.

 

Thanks

[Jack_mcs]

Don't do a delete, just update the data. I haven't tried this but it should work. Make a copy of the table and try it on the copy first.

UPDATE ORDERS SET cc_number=NULL;

 

Jack

[DriWashSolutions]

Don't do a delete, just update the data.  I haven't tried this but it should work.  Make a copy of the table and try it on the copy first.

UPDATE ORDERS SET cc_number=NULL;

 

Jack

<{POST_SNAPBACK}>

 

EXCELLENT - Exactly what I was looking for, and yes indeed, it did work.

 

Thanks Jack.