I Am Nothing

TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_product_bundle_selection`; TRUNCATE TABLE `catalog_product_entity_dat...

INSERT INTO `alsobuy_order_item` (`person`,`product_id`,`times`) SELECT * FROM ( ( SELECT CONVERT(o.customer_id,CHAR) AS `person`, oi.product_id, FLOOR(UNIX_TIMESTAMP(DATE_FORMAT(o...

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_product_bundle_selection`; TRUNCATE TA...

alter table [TABLE NAME] convert to character set utf8 collate utf8_unicode_ci;  

看这样一个关系Customers(cust_id,cust_name,cust_contact)Orders(order_num,cust_id,order_date)如果有这样的检索语句： select cust_name,cust_contact,( select count(*) from Orders where Order...

You can build your $param array by merging the existing data with the products already assigned as crosssells.You can get a list of the crosssels like this: $crosssells = $product->getCrossSellP...

to search the video swf url from web. and then use these phtml to show video image and url link   <div class="image-box"> <a class="fancybox image_gal" rel="iframeLink" href="<?ph...

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `core_url_rewrite`; TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_pr...

SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE eav_attribute_option_value; TRUNCATE TABLE `eav_attribute_option`; SET FOREIGN_KEY_CHECKS = 1;