Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    591
    Plugin Contributions
    0

    Default how can clean table from the database

    in my products have this

    Meta Tag Keywords:
    Meta Tag Description:


    where is the table can clean all ? i have about 500 products with Meta Tag Keywords:, Meta Tag Description:

    i want clean this table so this table empty for all products .

    thank you for understand .

  2. #2
    Join Date
    Jan 2014
    Location
    Arizona
    Posts
    110
    Plugin Contributions
    2

    Default Re: how can clean table from the database

    If I understand your English correctly, you need to clear the meta tag keywords and descriptions.

    I'm not very good at writing php code, but if anyone out there could writeup a code somewhat like this one:

    Code:
    UPDATE products SET products_tax_class_id=1;
    This code works for setting the tax class on all the products to 1, not sure if a modified code would work for setting the meta tags to null.

 

 

Similar Threads

  1. Replies: 3
    Last Post: 25 Sep 2013, 10:11 PM
  2. Can I just upgrade from to the new version without doing a clean install?
    By peterdrozd in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 30 Apr 2010, 03:02 PM
  3. how to show data from database table?
    By jibon in forum General Questions
    Replies: 1
    Last Post: 20 Oct 2009, 05:36 PM
  4. How can I change prices from within the database (not controlpannel) v1.2.7
    By ovdjajoh in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 5
    Last Post: 20 Sep 2008, 08:53 AM
  5. How can I put back the countries I deleted from the database?
    By whitknits in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 20 Dec 2007, 03:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg