Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL statement undo problem


garyww

Recommended Posts

Also, SQL statement, if I go to myphpadmin>database>SQL

And put

INSERT INTO `configuration` VALUES ('', 'Best Seller Days', 'BESTSELLER_DAYS', '30', 'Last X days sales for Best Seller List', 3, NULL, '2004-11-25 21:52:09', '0000-00-00 00:00:00', NULL, NULL);

INSERT INTO `configuration` VALUES ('', 'New Product Days', 'NEW_PRODUCT_DAYS', '90', 'Last X days products for New Products List', 3, NULL, '2005-06-09 15:09:26', '0000-00-00 00:00:00', NULL, NULL);

And press ‘go’or ‘run’. It done.

However, I do not want the abovesaid-mentioned statement put it to the database. I want to undo it. But I press go or run of the above SQLstatement.

How can I ‘undo it’ too.

Link to comment
Share on other sites

In myphpadmin>database>SQL click on the table name configuration in the left column.

 

Click on Browse, click on >> and click on the X next to the 2 records you want to delete.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...