MySql ÅжϺº×Ö¡¢ÈÕÆÚ¡¢Êý×ֵĺ¯Êý
¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION fc_is_hanzi(
p_str VARCHAR(1024)
)
RETURNS int(11)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT '¼ì²é×Ö·û´®ÊÇ·ñΪºº×Ö'
BEGIN
/*¼ì²é×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö*/
DECLARE _ret, i, other_cnt, l_acode INT DEFAULT 0;
SET _ret = 0;
SET i = 1;
SET other_cnt = 0;
SET l_acode = 0;
WHILE i <= CHAR_LENGTH(p_str) DO
SET l_acode = ASCII(SUBSTRING(p_str, i, 1));
IF l_acode<124 or l_acode>254 THEN
SET other_cnt = other_cnt + 1;
END IF;
SET i = i + 1;
END WHILE;
IF other_cnt = 0 THEN
SET _ret = 1;
ELSE
SET _ret = 0;
END IF;
RETURN _ret;
END;
/*****************************************************
2.ÅжÏÈÕÆÚ¸ñʽÊÇ·ñÕýÈ·£¨·µ»ØÖµ£º1-ÕýÈ· 0-´íÎó£©
*****************************************************/
DROP FUNCTION IF EXISTS fc_ck_date;
CREATE FUNCTION fc_ck_date(
p_cont CHAR(32)
)
RETURNS tinyint(4)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT 'Åж¨ÈÕÆÚ¸ñʽÊÇ·ñÕýÈ·'
BEGIN
/*Åж¨ÈÕÆÚ¸ñʽÊÇ·ñÕýÈ·£¨·µ»ØÖµ£º1-ÕýÈ· 0-´íÎó£©*/
/*ÊäÈëÖµ¸ñʽΪ£ºyyyyMMdd »ò yyyy-MM-dd*/
IF(SELECT DATE_FORMAT(p_cont
Ïà¹ØÎĵµ£º
Ò»¡¢²ÎÕÕÍêÕûÐÔ(Referential integrity)ºÍÍâ¼ü(foreign key)
²ÎÕÕÍêÕûÐÔ(Referential integrity)ÊÇÓÃÓÚÔ¼¶¨Á½¸ö¹ØÏµÖ®¼äµÄÁªÏµ£¬ÀíÂÛÉϹ涨£ºÈôMÊǹØÏµSÖеÄÒ»ÊôÐÔ×飬ÇÒMÊÇÁíÒ»¹ØÏµZµÄÖ÷¹Ø¼ü×Ö£¬Ôò³ÆMΪ¹ØÏµS¶ÔÓ¦¹ØÏµZµÄÍâ¹Ø¼ü×Ö¡£ÈôMÊǹØÏµSµÄÍâ¹Ø¼ü×Ö£¬ÔòSÖÐÿһ¸öÔª×éÔÚMÉϵÄÖµ±ØÐëÊÇ¿ÕÖµ»òÊǶÔÓ¦¹ØÏµZÖÐij¸öÔª×éµÄÖ÷¹ ......
lect ASIN('foo');
¡¡¡¡-> 0.000000
ATAN(N)
¡¡·µ»ØNµÄ·´ÕýÇÐÖµ
mysql> select ATAN(2);
¡¡¡¡-> 1.107149
mysql> select ATAN(-2);
¡¡¡¡-> -1.107149
ATAN2(X,Y)
¡¡·µ»Ø2¸ö±äÁ¿XºÍYµÄ·´ÕýÇÐ(ÀàËÆY/XµÄ·´ÕýÇÐ,·ûºÅ¾ö¶¨ÏóÏÞ)
mysql> select ATAN(-2,2);
¡¡¡¡-> -0.785398
mysql> ......
ÓÐʱºòΪÁË·½±ã£¬ÀûÓÃevent/triggerµ÷ÓÃϵͳÍⲿÃüÁ¿ÉÒòΪ°²È«ÎÊÌ⣬mysql×ÔÉí²¢Ã»ÓÐÌṩÏà¹ØÃüÁÕâÀïÌṩ¸öµ÷ÓÃϵͳÃüÁîµÄ×Ô¶¨Ò庯Êýmylab_sys_exec
soÎļþÏÂÔØ:mylab_sys_exec.so ( mysql5.1.34 ²âÊÔͨ¹ý)
¼ÓÔØ:
CREATE FUNCTION mylab_sys_exec RETURNS INTEGER SONAME "mylab_sys_exec.so";
ʹÓÃ:
SELECT myl ......
×Ö¶ÎpageNum
1£¬6£¬9£¬11
Ï£ÍûÅÅÐò˳ÐòΪ1£¬6£¬9£¬11
µ«ÊÇʵ¼ÊÅÅÐòΪ1£¬11£¬6£¬9
ºóÀ´·¢ÏÖÊÇÒòΪpageNumÕâ¸ö×Ö¶ÎÊÇvarcharÀàÐ͵IJ»ÊÇintÐÍ£¬ËùÒÔÅÅÐò»á³öÎÊÌâ¡£
ÍøÉϵĽâ¾ö·½·¨Îª
order by pageNum+0
order by pageNum×1
²»ÖªµÀΪʲôorder by pageNum×1 Êý¾Ý¿âͨ²»¹ý
µ«ÊÇpageNum+0ÊǺÃÓÃµÄ ......
°´ÕÕ¹Ù·½ÌṩµÄ“UCenter 1.5.0 °²×°Í¼ÎĽ̳̔£¬ÎÒ¿ªÊ¼×°ÉÏphp5,mysql5,apache2.2£¬½á¹ûÔÚhttp://127.0.0.1/ucenter/install/index.phpʱÓöµ½ÁËÁîÈËÓôÃÆµÄÒ»¿Ì£¬
²é²é×ÊÁÏÒ»¿´£¬ÓкܶàÅóÓѶ¼Óöµ½ÀàËÆÇé¿ö£¬¶øÇÒÎʵÄÌû×Óµ½ÏÖÔÚ»¹Ã»Óиø»Ø£¬ÐÄÀíÄÉÃÆÑ½£¬ÎªÉ¶UcenterµÄÌṩ¹«Ë¾“¿µÊ¢´´Ï딵Ŀª·¢ÈËÔ±²» ......