javatophp
- 浏览: 71807 次
- 性别:
- 来自: 深圳
-
最新评论
-
szcs10138456：
<script>alert(1);</scr ...
php性能监测模块XHProf -
walle1027：
总结的非常全面，感谢博主。
postgresql sql 总结 -
输入法：
其他两种方式呢？
php 3种安装方法
文章列表
(0)解决冲突 (分析原因)
[root@host150 svntest]# svn ci -m " " a.php
正在发送 a.php
传输文件数据.svn: 提交失败(细节见下)：====>有冲突 服务器版本为10127 ,而本地版本为10126说明刚才有人已经提交过一个版本
svn: Out of date: '/svntest/a.php' in transaction '12127-1'
[root@host150 svntest]# svn log a.php
------------------------ ...
pg对大写字母的处理 列名要加双引号
添加一个 AA列
-- Column: "AA"
-- ALTER TABLE "version" DROP COLUMN "AA";
ALTER TABLE "version" ADD COLUMN "AA" character varying;
ALTER TABLE "version" ALTER COLUMN "AA" SET STORAGE EXTENDED;
ALTER TABLE &quo ...
exchange=# select invoice_id, client_id , total_amount,invoice_end from invoice order by invoice_id ;
invoice_id | client_id | total_amount | invoice_end
------------+-----------+--------------+------------------------
31 | 1 | 14.06202 | 2010-12-20 00:00:00+ ...
--按年分组查看
select to_char(to_timestamp(start_time_of_date::bigint), 'YYYY') as d , count(cdr_id) as total_call,sum (call_duration::integer /60 +1) as total_duration from cdr
where to_timestamp(start_time_of_date::bigint) between '2010-01-01' and '2010-12-12' group by d
...