摘要: select substring('1ssssss',1,2);select INSTR('ss,ss,s,ss', ',');select LEFT('ss,sss,ss',2); 阅读全文
posted @ 2011-04-19 16:03 Jake.Xu 阅读(201) 评论(0) 推荐(0) 编辑
摘要: DELIMITER $$DROP PROCEDURE IF EXISTS `auo`.`TTT` $$CREATE DEFINER=`root`@`localhost` PROCEDURE `TTT`(OUT RESULT INT,IN CC VARCHAR(20))BEGINDECLARE l_last_row_fetched int;DECLARE COUNTRYT VARCHAR(20);DECLARE GUIDT INT;#DECLARE RESULT INT;#set RESULT = 0;#SELECT INTO RESULT = 0;#OPEN TT;DECLARE TT CUR 阅读全文
posted @ 2011-04-19 14:01 Jake.Xu 阅读(239) 评论(0) 推荐(0) 编辑