pjones Posted March 12, 2003 Share Posted March 12, 2003 I need to use phpMyAdmin to delete all credit card numbers in my database. I know I can delete the entire order table, but I just want to clear the card numbers. Anyone know how to do this? Link to comment Share on other sites More sharing options...
mattice Posted March 12, 2003 Share Posted March 12, 2003 use a simple SQL command or edit each manually "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
mattice Posted March 12, 2003 Share Posted March 12, 2003 http://www.mysql.com/doc/en/DELETE.html is a good reference... something like: DELETE from table orders WHERE cc_number != "" UNTESTED. Backup. :D "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Ajeh Posted March 13, 2003 Share Posted March 13, 2003 Stop! Wait! Not DELETE! :onfire: I think you want to remove the data in the orders table field cc_number Use UPDATE orders set cc_number='' where <add conditions here> DELETE is remove the order itself. Link to comment Share on other sites More sharing options...
pjones Posted March 13, 2003 Author Share Posted March 13, 2003 I do want to clear the cc_number field, not delete the order. Is there a simple way to do this in phpMyAdmin? I'm not familiar with the exact mysql syntax, so any help would be appreciated. I hoped there would be a simple gui process to do this. Link to comment Share on other sites More sharing options...
Ajeh Posted March 13, 2003 Share Posted March 13, 2003 What is the conditions for when you want to clear them? The UPDATE command can set the value of the field for everything or based on a condition in the where statement. Link to comment Share on other sites More sharing options...
mattice Posted March 13, 2003 Share Posted March 13, 2003 UNTESTED. Backup. :D Good thing I used that disclaimer :D DELETE deletes rows from table_name that satisfy the condition given by where_definition, and returns the number of records deleted. "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Ajeh Posted March 13, 2003 Share Posted March 13, 2003 DELETE is just such a harsh and permanent word ... 8) Link to comment Share on other sites More sharing options...
griffin Posted June 15, 2003 Share Posted June 15, 2003 Has anyone used the clear credit card contribution? I got grey hair with osCommerce. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.