消失的手套

摘要： 1. 已查询Test的建表语句为例： SHOW CREATE TABLE TEST2. mysql中select limit的使用和oracle中select rownum的使用 3.修改字段的长度 alter table 表名 modify column 字段名 类型; 4.修改字段长度 5. I 阅读全文

摘要： SELECT count(1) FROM (select t2.mainuser from lims_folderservgrp t1 left join lims_folders t2 on t1.foldersid = t2.foldersid left join lims_clearancef 阅读全文

摘要： select count(1) from lims_folderservgrp t2 left join lims_folders t1 on t1.foldersid = t2.foldersid left join lims_clearanceform t on t1.clearanceid = 阅读全文

摘要： SELECT count(1) FROM (select t.folderservgrpid from lims_folderservgrp t--fs表里有几个科室显示几条数据 left join lims_folders t2 on t.foldersid = t2.foldersid and 阅读全文

摘要： select count(1) from (select l.isrepeat from lims_folders t join base_corp p on t.submitcorp = p.corpcode join lims_clearanceform l on t.clearanceid = 阅读全文

摘要： 正式服更新到V2020032302（流程监控增加SQL初始化） /home/app/apache-tomcat-8.5.35/logs tail -f catalina.outtail -f catalina-2020-03-23.out select b.userdesc,d.* from lim 阅读全文

摘要： 客户有时候会出现前后需求完全不一样的情况，听清楚现在这一次的需求，听取一部分上次的需求。 阅读全文

摘要： update lims_ordtask lo set lo.cnas = '1' where exists (select 1 from lims_folders f where lo.foldersid = f.foldersid and f.folderno in ('NJ2020MS0095' 阅读全文

摘要： select *from lims_sp_tests s where select sys_guid() from dual select *from lims_sample_programs c where c.progname like '%de%'select * from LIMS_DOMA 阅读全文

摘要： 阅读全文