![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
宅男当道
这个作者很懒,什么都没留下…
展开
-
mysql 添加主键
Alter table tb add primary key(id);Alter table tb change id id int(10) not null auto_increment=1;原创 2013-10-13 23:53:04 · 1614 阅读 · 0 评论 -
oracle 用over进行累计计算
create or replace view sumproinvview(guid, proguid, prono, proname, proclass, process, auditmoney, year, month, moninv, suminv, sumpercent)asselect guid,proguid,prono,proname,proclass,process,audit原创 2014-01-24 14:59:10 · 2202 阅读 · 0 评论