数据库
iteye_13815
这个作者很懒,什么都没留下…
展开
-
Linux上安装Mysql
Cache Server Configuration Manual 1、Operation System Requirement: RedHat Linux AS 4 update 4 2、Package Installation: 1) Editors 2) Server Configuration Tools 3) Development Tools 4) Administ...原创 2010-08-26 16:47:02 · 132 阅读 · 0 评论 -
解决hibernate+mysql出现的隔天连接超时问题
[code="java"]出现错误:SQL Error: 0, SQLState: 08S01 Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software cau...原创 2010-03-07 19:05:56 · 143 阅读 · 0 评论 -
数据库表行列转换
不用写存储过程就能实现,也不用特殊的函数就能搞定行列转换了 [code="java"] create table student ( s_name varchar(20), s_subject varchar(20), s_point int ) insert into student values('张三','数学',86) insert into student v...2009-10-13 11:40:07 · 117 阅读 · 0 评论 -
查询表中第n行到第m行的数据
方法一: [code="java"]select * from(select top m-n+1 * from (select top m * from table1 order by id asc) as table2 order by id desc) as table3 order by id[/code] --注释: --table1 是你要查询的数据表名 -...2009-10-13 16:19:55 · 493 阅读 · 0 评论 -
SQL函数大全
[code="java"]use pubs go select distinct price from titles where type='business' -- distinct去掉重复的记录 select avg(distinct price) --算平均数 from titles where type='business' go use pubs go se...原创 2009-10-14 11:09:43 · 88 阅读 · 0 评论