知识点:时间戳转化,当前时间,左连接,查询的字段相同可以直接插入另一张表 insert into lqioc_ioc_dw.kkjcselect a.*,b.CLL,e.JZT from (select FROM_UNIXTIME(UNIX_TIMESTAMP(),'yyyy') as YEAR_ID,'鹿泉' as AREA_NAME,'130185000000' as AREA_N
问题SQL: select p.person_id as personId, p.person_name as personName, p.native_place as nativePlace, ci.company_name as companyName, pp.seal_number as sealNumber, GROUP_CONCAT(pp.major) as major, pp.re
http://linux.cn/article-3820-1-qqmail.html Linux 平台上的性能工具有很多,眼花缭乱,长期的摸索和经验发现最好用的还是那些久经考验的、简单的小工具。系统性能专家 Brendan D. Gregg 在最近的 LinuxCon NA 2014 大会上更新了他那个有名的关于 Linux 性能方面的 talk (Linux Performan