1.获取单条记录
$row = $GLOBALS[
'db'
]->getRow($sql);
2.获取单一字段
$row = $GLOBALS[
'db'
]->getOne($sql);
查询产品总数
$num = $GLOBALS[
'db'
]->getOne(‘SELECT COUNT(*) FROM ‘ . $GLOBALS[
'ecs'
]->table(‘goods’) ;
3.获取所有记录
$row = $GLOBALS[
'db'
]->getAll($sql);
4.执行sql语句
$res = $GLOBALS[
'db'
]->query($sql);
//执行删除(DELETE),插入(INSERT),更新(UPDATE)等操作可用此方法
5.把数组元素插入数据库
$parent[
'goods_number'
] = ’1′;
$parent[
'parent_id'
] = 0;
$GLOBALS[
'db'
]->autoExecute($GLOBALS[
'ecs'
]->table(‘cart’), $parent, ‘INSERT’);
6、批量修改 商品的“库存警告数量”
例如:将所有的库存警告数量修改为45,那么可以运行下面SQL语句
update `ecs_goods` set warn_number='45'
7、用SQL语句搜索“2010-12-12”之前更新的所有商品:
注意:数据表前缀是默认前缀的情况下
SELECT * FROM `ecs_goods` WHERE last_update < unix_timestamp('2010-12-12 00:00:00')
8、update ecs_goods SET goods_number= '5000' 设置所有演示数据库存数为5000 update ecs_ad set end_time='1625846400' 设置广告结束时间 UPDATE ecs_goods SET promote_end_date = '1625846400' where promote_end_date <>0 设置促销商品的促销结束时间
UPDATE ecs_goods SET goods_number= '2000' 设置产品库存数量删除ECSHOP所有商品的精品属性:
update ecs_goods set is_best = '0' 删除所有产品的新品属性:
update ecs_goods set is_new = '0' 删除所有产品的热销属性:
update ecs_goods set is_hot = '0' 依次类推,删除所有促销商品就是:
update ecs_goods set is_promote = '0' 删除表 delete from ecs_xxx;(xxx=要删除的表)
9、并非适用于所有人。特别注意:操作前注意备份好数据库。
(1)ECSHOP更新商品静态url:
UPDATE ec272u2.ecs_goods SET goods_url = '4545444' WHERE ecs_goods.goods_id =3509 LIMIT 1 ;
(2)ECSHOP更新商品seo标题:
ALTER TABLE ecs_category ADD cat_seoname VARCHAR( 255 ) NOTNULLAFTER cat_seoname
(3)ECSHOP更新商品clicks_count到小于800的点击:
UPDATE [Case] SET click_count = click_count + CAST(CEILING(RAND(checksum(NEWID())) * 800) AS int) WHERE (Hits < 100) ;
UPDATE ecs_goods SET click_count = click_count + 100 WHERE (click_count < 100);
(4) ECSHOP更新商品salesvolume AND (/**FLOOR(x)返回小于x的最大整数值 RAND() 返回在范围0到1.0内的随机浮点值2。
ALTER TABLE ecs_goods ADD goods_salesvolume inNULLods_weight ;
UPDATE ecs_goods set goods_salesvolume= FLOOR(1 +(RAND() * 2345));
(5) ECSHOP批量更新替换货号
UPDATE ecs_goods SET goods_sn = CONCAT('it',goods_id,'-', seller_note) where ;
(6) ECSHOP更新订单初始基数,批量上下架
alter table ecs_order_info AUTO_INCREMENT=10000;
UPDATE ecs_goods SET is_on_sale = 1 where goods_id > ;
(7)ECSHOP批量更新替换商品名称
UPDATE ecs_goods SET goods_name = replace (goods_name,'Kate Co','') WHERE goods_name` LIKE '%Kate&Co%'; 分大小写
请注意:操作会直接影响数据库,以防万一,请操作前注意备份。