
mysql
iteye_14261
这个作者很懒,什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
清空所有分类和商品的SQL语句
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...2013-05-15 09:49:45 · 382 阅读 · 0 评论 -
统计每N个小时的人头和订单商品(ITEM)
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...原创 2013-11-15 14:04:03 · 139 阅读 · 0 评论 -
Magento 1.8 Clean All Categories And Products By Sql
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...2014-02-19 15:18:04 · 117 阅读 · 0 评论 -
convert table and column collection to UTF-8
alter table [TABLE NAME] convert to character set utf8 collate utf8_unicode_ci;原创 2014-04-09 17:16:38 · 145 阅读 · 0 评论 -
分析一下聚合函数与连接表的组合使用
看这样一个关系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...2013-04-20 12:22:50 · 395 阅读 · 0 评论 -
Update or add crosssell product
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...2014-07-09 13:45:26 · 99 阅读 · 0 评论 -
Magento Use FancyBox to load YOUKU Video
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...2014-09-19 11:54:18 · 325 阅读 · 0 评论 -
truncate all product data ON CE 1.9
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...2014-11-07 11:17:07 · 123 阅读 · 0 评论 -
magento clean all dopdown and multyselect options data
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE eav_attribute_option_value;TRUNCATE TABLE `eav_attribute_option`;SET FOREIGN_KEY_CHECKS = 1;2014-11-08 10:00:46 · 95 阅读 · 0 评论