MySQL IP字符串转数字存储过程
摘要:
DELIMITER$$USE`db_im`$$DROPPROCEDUREIFEXISTS`P_bi_parasIP`$$CREATEDEFINER=`root`@`localhost`PROCEDURE`P_bi_parasIP`(INPi_ipstrVARCHAR(50),OUTPo_int1INT,OUTPo_int2INT,OUTPo_int3INT,OUTPo_int4INT,OUTPo_retINT)BEGINDECLAREv_strtempVARCHAR(50);DECLAREv_posINT;DECLAREv_subVARCHAR(10);DECLAREv_tailVARCHAR 阅读全文
posted @ 2012-03-05 22:19 心笑峰 阅读(1902) 评论(0) 推荐(0) 编辑