java电商源码分享

[code="sql"]Select * From rm_article As A Where (Select Count(0) From rm_article Where cid=A.cid And aid >= A.aid group by cid)

DROP PROCEDURE IF EXISTS sp_name;create procedure sp_name()begindeclare _userid,_id,no_rs int;declare sitelist CURSOR for select userid,id from eop_site ;DECLARE CONTINUE HANDLER F...

一.创建存储过程1.基本语法：create procedure sp_name()begin………end2.参数传递二.调用存储过程1.基本语法：call sp_name()注意：存储过程名称后面必须加括号，哪怕该存储过程没有参数传递三.删除存储过程1.基本语法：drop procedure sp_name//2.注意事项(1...

  select c.*,count(s.cat_id) from js_goods_cat as c left join js_goods_cat as s on s.parent_id = c.cat_id group by c.cat_id order by parent_id,cat_order   

导出前接行 CREATE OR REPLACE VIEW exu9tne (tsno, fileno, blockno, length) ASSELECT ts#, segfile#, segblock#, lengthFROM sys.uet$WHERE ext# = 1UNION ALLSELECT * FROM SYS.EXU9TNEB 

/*添加字段*/alter table DY_COOPERATE add AREA_STR varchar2(255); /*删除字段*/alter table DY_COOPERATE drop column AREA_STR; /*修改字段名*/alter table DY_COOPERATE rename column AREA_STR to AREA_STR1;  /*...

寻子： SELECT * FROM shop_syscategory sCONNECT BY　 PRIOR id= parentid START WITH s.id = 11  寻父：SELECT * FROM shop_syscategory sCONNECT BY　id= PRIOR parentid START WITH s.id = 500090...

select * from (Select distinct name,categoryId,parentid,sort_order From shop_category START WITH parentid IS NULL Connect by parentid = prior categoryId order by sort_order) Start with pare...

update tb set updateTime=to_date('2008-09-10 12:11:11','yyyy-MM-dd HH24:mi:ss')

//主键549830479 alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);//增加一个新列549830479 alter table t2 add d timestamp;...