fmt.replace(RegExp.$1, (this.getFullYear() + "").substr(4 - RegExp.$1.length)); for (var k in o) if (new RegExp("(" + k + ")").test(fmt)) fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length))); return fmt;}调用: var time1 = new Date().For
fmt.replace(RegExp.$1, (this.getFullYear() + "").substr(4 - RegExp.$1.length)); for (var k in o) if (new RegExp("(" + k + ")").test(fmt)) fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length))); return fmt;}//var now = new Date();///
,1234444,dsfdd,sd,sd'||',' UNION ALL SELECT substr(str, 0, instr(str, ',')), substr(str, instr(str, ',')+1) FROM split WHERE str!='') SELECT word FROM split WHERE word!='';
id = 104703;MySql:1、同Sqlserver和Oracle前4点2、LOCATE('substr',str,pos)方法SELECT LOCATE('bar',`foobarbar`); ###返回43、POSITION('substr' IN `field`)方法SELECT `column` FROM `table` WHERE POSITION('keyword' IN `filed`)4、INSTR(`str`,'substr')方法SELECT `column` FROM `table` WHERE INSTR(`field`, 'keyword' )>05、FI
-@l+1 BEGIN
INSERT @tb1(child)VALUES(SUBSTRING(@word1, @l, @i));
SET @i=@i+1;
END;
SET @i=1;
SET @l=@l+1;
END;
SET @i=1;
SET @l=1;
WHILE @l<=LEN(@word2)BEGIN
WHILE @i<=LEN(@word2)AND @i<=LEN(@word2)-@l+1 BEGI
art,end)可以作用于字符串的切割/*字符串切割和提取----slice(start,end),substring(),substr()*/
var str = "Hello,world!";
var sliceStr = str.slice(1,5);//ello (不包含end)
var subStr = str.substring(1,5);//ello
var subStr = str.substr(1,5);//ello,
var str = "1000000";
var sliceStr = str.slice(-3);//000 从
在MySQL中,可以用 Limit 来查询第 m 条到第 n 条的记录,例如:select * from tablename limit m, n在SQL Server中,不支持 Limit 语句,但是它支持 TOP。select top n-m 1 * from [tableName] where (id not in (select top m-1 id from [tableName]))