摘要:
<script> function onSubmitPlus(issave) { var projectid=$("#field_40282aa18708cb1301871197556b011b").val(); var projectmgrdep=$("#field_40282aa18708cb1 阅读全文
摘要:
一千条之前需要下面的语句 select top 1000 id from project order by id 一千条之后需要下面的语句 select top 1000 id from project where isdelete=0 and id not in(select top 10000i 阅读全文
摘要:
//注册地址var province = SQL("select province from project where code='"+code+"' and isdelete=0 order by indate limit 1 ");$("#field_2c923daf70a540290170a 阅读全文
摘要:
--DELIMITER $$ CREATE FUNCTION `func_get_split_string_total`( f_string varchar(1000),f_delimiter varchar(5) ) RETURNS int(11) BEGIN -- Get the total n 阅读全文
摘要:
1.把查询结果用逗号拼接 select group_concat(objname) from humres 2. 把两列的数据拼接在一起 select objname,group_concat(concat_ws('-',id,objname)order by id) as v from humre 阅读全文