Posts for Tag: sql

SQL query to display database size in MB


Display Mysql database size in MB Query

Magento change product meta data by SQL Queries


Editing contents of meta data for a big product base, can be very time consuming. But You can always use SQL… 1. Get atributte_id for meta data:

The result should be similiar to:

We’ll use the attribute_id in the next query. The backend_type determines in which table the data is kept. For exampleRead More