¹ØÓÚMySQL ORDER BY
ÓÉÓÚϵͳÐèÒª£¬Ð´ÁËÒ»¸öORDER BY µÄSQL²éѯÓï¾ä½øÐÐ×Ö¶ÎÅÅÐò£¬²éѯ½á¹ûûÓнøÐÐÅÅÐò£¬SQLÓï·¨ÕýÈ·£»
ÓÚÊÇ£¬½øÈëMySQL¿ØÖÆ̨£¬Ö´ÐÐSQLÓï¾ä£¬Ã»Óб¨´í£¬µ«ÊǾÍÊÇûÓÐÅÅÐò£»
¾¹ý²éÕÒ·¢ÏÖ£¬ÔÚд ORDER BY ' time' DESC Óï¾äÖУ¬Ê¹ÓÃÁË“ ' ”·ûºÅ£¬µ¼ÖÂMySQLÎÞ·¨Õý³£½âÎö£¬È¥µôÅÅÐòÕý³££»
»òÕß¿ÉÒÔÓà “`”Õâ¸ö´úÌ棬¼´ ORDER BY ` time` DESC£»
ËäÈ»ÕÒµ½´íÎóÔÒò£¬µ«ÊDz»Öª “`”ºÍ “ ' ”ÔÚSQLÓï¾äÖеÄÇø±ð£¬Ï£ÍûÓÐÖªµÀµÄ¸ßÈËÖ¸µ¼¡£
·Ç³£¸Ðл£¡£¡£¡
Ïà¹ØÎĵµ£º
cacti ¼à¿Ø mysql
»·¾³£º
Cactiez»òÕßcactiÖ÷»ú£º192.168.12.5
±»¼à¿ØmysqlÊý¾Ý¿âÖ÷»ú£º192.168.5.231
1. °²×°¼à¿Ø²å¼þ
cd /opt
wget http://mysql-cacti-templates.googlecode.com/files/mysql-cacti-templates-1.1.6.tar.gz
tar -xzvf mysql-cacti-templates-1.1.2.tar.gz
cp /opt/mysql-cacti-templates-1.1.2 ......
I promise this is gonna be the last time on it :-)
×Ô從寫ÍêÏÂÃæ兩ƪÎÄÕ£º
wordpress 1.5Éý級×¢ÒâÊÂ項 - ÖÐÎÄ亂碼ƪ
mysql 4.1ÖÐÎÄ亂碼µÚ¶þ擊
過È¥幾個Ô¾Ͳ»斷ÓÐ來ÐÅ詢問¸÷種 mysql ÖÐÎÄÏàÈÝµÄ ......
MySQL(rootÓû§)ÃÜÂëÍü¼ÇÖØÖÃ
·Ö±ðÔÚWindowsϺÍLinuxÏÂÖØÖÃÁËMYSQLµÄrootµÄÃÜÂ룬ÕûÀíÈçÏ£º
¡¡¡¡A£ºÔÚwindowsÏ£º
¡¡¡¡1£º½øÈëcmd£¬Í£Ö¹mysql·þÎñ£ºNet stop mysql
¡¡¡¡ µ½mysqlµÄ°²×°Â·¾¶Æô¶¯mysql£¬ÔÚbinĿ¼ÏÂʹÓÃmysqld-nt.exeÆô¶¯£¬
¡¡¡¡2£ºÖ´ÐУºmysqld-nt --skip-grant-tables£¨´°¿Ú»áһֱֹͣ ......
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñËùÓÐ date_col ÖµÔÚ×îºó 30 ÌìÄڵļǼ¡£
mysql> SELECT something from tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;
DAYOFWEEK(date) ·µ»Ø date µÄÐÇÆÚË÷Òý(1 = Sunday, 2 = Monday, ... 7 = Saturday)¡£Ë÷ÒýÖµ·ûºÏ ODBC µÄ±ê×¼¡£
mysq ......
¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËƵãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØѧ»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊ×ƪ£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......