Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃÌØÊâµÄMySQLÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ

ÓÃÌØÊâµÄMySQLÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ
Èç¹ûÄãÔÚ×î½ü½øÐйýSELECT»òUPDATE²éѯ£¬ÄÇôÄãºÜ¿ÉÄÜÓõ½¹ýÒ»¸ö»òÕß¶à¸öMySQLµÄ±È½ÏÔËËã·ûÀ´ÏÞÖÆ²éѯµÄÊä³ö½á¹û¡£±È½ÏÊÇ´ó¶àÊýSELECT²éѯ²»¿É·Ö¸îµÄÒ»²¿·Ö£¬¶øMySQLΪÕâÒ»¹¦ÄÜÌṩÁ˺ܶຯÊý£»¸ù¾Ý×î½üÒ»´Îͳ¼Æ£¬ËüÓг¬¹ý20¸öÕâÑùµÄÔËËã·ûºÍº¯Êý£¬´ÓÖøÃûµÄ=ºÍLIKEµ½¸ü¼ÓÄѶ®µÄNOT INºÍSTRCMP()¡£
±¾ÎİÑÖØµã·ÅÔÚһЩ²»Ì«³£¼ûµÄMySQLÊý¾Ý±È½Ïº¯ÊýºÍÔËËã·ûÉÏ£¬ÌÖÂÛËüÃÇ¿ÉÒÔ±»ÈçºÎÔËÓÃÔÚÓ¦ÓóÌÐòÀï±È½Ï±í¸ñ×Ö¶ÎÀïµÄ×Ö·û´®¡¢Êý×ÖºÍÈÕÆÚ£¯Ê±¼ä»òÕßÓû§ÌṩµÄÖµ¡£
 
BETWEEN
BETWEENÔËËã·ûÊDzâÊÔÔÚij¸ö·¶Î§ÄÚÊÇ·ñ´æÔÚÒ»¸öÊýÖµ»òÕßÈÕÆÚÖµµÄÓÐÓ÷½Ê½¡£Õâ¸öÔËËã·û½ÓÊÜÁ½¸ö²ÎÊý——×î´óÖµºÍ×îСֵ£¬²¢²âÊÔËùÌṩµÄÖµÊÇ·ñÔÚÕâÁ½¸öÖµµÄ·¶Î§Ö®ÄÚ¡£Èç¹ûÔÚÕâ¸ö·¶Î§Ö®ÄÚ£¬ÔËËã·û¾Í·µ»ØÒ»¸ö²¼¶ûÖµ——Õæ£»·ñÔò£¬Ëü¾Í·µ»ØÒ»¸öαֵ¡£ÏÂÃæ¾ÍÊÇÒ»¸öÀý×Ó£º
            mysql> SELECT 2350 BETWEEN 100 AND 10000;
            +----------------------------+
            | 2350 BETWEEN 100 AND 10000 |
            +----------------------------+
            |¡¡1 |
            +----------------------------+
            1 row in set (0.18 sec)
ÏÂÃæÁ½¸öÀý×ÓÓõ½ÁËÈÕÆÚÖµ£º
            mysql> SELECT 20060405 BETWEEN 20060101 AND 20070101;
            +----------------------------------------+
            | 20060405 BETWEEN 20060101 AND 20070101 |
            +----------------------------------------+
            |¡¡1 |
 &nb


Ïà¹ØÎĵµ£º

ÓÃMySQL´´½¨Êý¾Ý¿âºÍÊý¾Ý¿â±í


ÓÃMySQL´´½¨Êý¾Ý¿âºÍÊý¾Ý¿â±í
Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
¡¡¡¡1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES; +----------+
| Database | +----------+ | mysql |
| test | +----------+ 3 rows in set (0.00 sec)
¡¡¡¡2¡¢´´½¨Ò ......

linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ

zz linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ
ÎҵķþÎñÆ÷×°µÄÊÇcentos 5.3,ÓÉÓÚ×ʼ°²×°×öÁËÏêϸµÄ¼Ç¼,ËùÒÔÕû¸ö¹ý³ÌÒ²ÊÇÇá³µÊì·,һ·yumÏÂÀ´£¬¾Í¸ã¶¨ÁË£¬È»ºó¾ÍÊÇÊý¾Ý¿â¡¢ÍøÕ¾µÄ°á¼Ò£¬ÇáËɸ㶨~
¿ÉÊǽñÌìÔÚ¼Ò¿´ÁËϹ«Ë¾µÄÍøÕ¾£¬ÎÊÌâ³öÀ´ÁË~ ÓÐЩ²úÆ·µã»÷²é¿´ÏêϸÐÅÏ¢µÄʱºò£¬ÕÒ²»µ½ÍøÒ³~¾­¹ýÒ»·¬Ë¼¿¼£¬·¢ÏÖÊÇmysql ......

Óà PHP µ÷Óà MySQL ´æ´¢¹ý³Ì

    MySQL 5.0 ÒÔÉÏÖ§³Ö´æ´¢¹ý³Ì¡£
    PHP 5.0 ÒÔÉ쵀 mysqli ϵÁк¯Êý¿ÉÒÔÖ§³Ö²Ù×÷ MySQL µÄ´æ´¢¹ý³Ì¡£
    ÒÔÏÂÊÇһЩ¼òµ¥µÄ´æ´¢¹ý³ÌºÍÓà PHP µ÷ÓõÄʾÀý¡£     Ò»¡¢·µ»Øµ¥¸öÊý¾Ý: 1: <?php
2: header("Content-Type:t ......

CentOS+Apache+Mysql+Php°²×°¼°ÓÅ»¯ÅäÖÃС¼Ç


±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ