ÓÃÌØÊâµÄ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 5.0 ÒÔÉÏÖ§³Ö´æ´¢¹ý³Ì¡£
PHP 5.0 ÒÔÉ쵀 mysqli ϵÁк¯Êý¿ÉÒÔÖ§³Ö²Ù×÷ MySQL µÄ´æ´¢¹ý³Ì¡£
ÒÔÏÂÊÇһЩ¼òµ¥µÄ´æ´¢¹ý³ÌºÍÓà PHP µ÷ÓõÄʾÀý¡£ Ò»¡¢·µ»Øµ¥¸öÊý¾Ý: 1: <?php
2: header("Content-Type:t ......
±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
µ¼³ö.sqlÎļþ
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db devi ......
Another Look at MySQL 5.1's SQL Diagnostic Tools
http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html Êý¾Ý¿âµÄÐÔÄܾö¶¨ÒòËØ£º
£¨1£©Êý¾Ý¿âµÄÉè¼Æ
£¨2£©SQL´úÂë ¿ÉÒÔÓÃÒÔϼ¸ÖÖ·½·¨À´½â¾öһЩÐÔÄÜÎÊÌ⣺
£¨1£©Ë÷Òý
£¨2£©Ë®Æ½·ÖÇø
£¨3£©ÁÐÊÊÓ¦µÄ±í
colum ......