Wireshark ×¥°üMySQLµÄ²éѯÓï¾ä
¹ýÂËÆ÷Ìõ¼þ
mysql.query contains "SELECT"
..
..
..
..
MySQL Protocol
Packet Length: 168
Packet Number: 0
Command
Command: Query (3)
Statement: EXPLAIN SELECT `GROUP_ID`,`MEMBER_ID`,`JOIN_DATETIME`,`IS_GROUP_MANAGER`,`IS_ADMIN` from `users` WHERE (`GROUP_ID` = '1') AND (`IS_GROUP_MANAGER` = 'T')
Ïà¹ØÎĵµ£º
ΪÁËÈÃÓû§²»ÐèÒª×Ô¼ºÔËÐÐmysql°²×°³ÌÐò°²×°mysqlÊý¾Ý¿â£¬Èí¼þ·¢²¼Ê±ÐèÒª´ò°üÃâ°²×°°æ±¾µÄmysql¡£´Ómysql¹ÙÍøÉÏÖ±½ÓÏÂÔØµÄÃâ°²×°°æ±¾ÐèÒª¸÷ÖÖÅäÖã¬Èç¹ûÅäÖò»ºÃ£¬ºÜÈÝÒײúÉú¸÷ÖÖ¸÷ÑùµÄÎÊÌâ¡£ÓÈÆäÊÇ´íÎóÂëΪ1067µÄÎÊÌ⣬ÎÒÊÔÑéÁËÍøÉϵĺܶ෽·¨¶¼Ã»Æð×÷Óã¬×îºóÏëÁËÒ»¸ö×î¼òµ¥µÄ·½·¨£º
£¨1£©Ê×ÏÈʹÓð² ......
Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊǰ´°´Å¥»»
ÒýÇæ£»ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇæ£¬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ÒâµÄ ......
ÎÒÃǾ³£»áÓöµ½ÐèÒª±í¸´ÖƵÄÇé¿ö£¬È罫һ¸ötable1µÄÊý¾ÝµÄ²¿·Ö×ֶθ´ÖƵ½table2ÖУ¬»òÕß½«Õû¸ötable1¸´ÖƵ½table2ÖУ¬ÕâʱºòÎÒÃǾÍҪʹÓÃSELECT INTO ºÍ INSERT INTO SELECT ±í¸´ÖÆÓï¾äÁË¡£
1.INSERT INTO SELECTÓï¾ä
Óï¾äÐÎʽΪ£ºInsert into Table2(field1,field2,...) select value1,v ......
¸Ã°æ±¾Éý¼¶ InnoDB ²å¼þµ½ 1.0.6 °æ±¾£¬Ä¿Ç° 1.0.6 °æ±¾µÄ InnoDB µÄÖÊÁ¿²î²»¶àÊÇ RC ºòÑ¡·¢Ðм¶±ðµÄ¡£ÁíÍâһЩÃüÁîÐй¤¾ß¸÷×ÔÔö¼ÓÁËһЩ²ÎÊýÑ¡ÏÏêÇéÇë¿´ÕâÀï¡£MySQL£¨·¢Òô£º[ˌmaɪ ɛs kjuː ˈɛl]£¬µ«Ò²¾³£¶Á×÷My- SEQuel£©ÊÇÒ»¸ö¿ª·ÅÔ´ÂëµÄ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¬¿ª·¢ÕßΪÈðµäMySQL AB¹«Ë¾£ ......
±àÂëÊǸöºÜ»ù´¡µÄÎÊÌ⣬ҲÊÇ´ó¼ÒºÜÈÝÒ׺öÂÔµÄÎÊÌ⣬д´úÂë֮ǰ¶à¶à¿¼ÂÇ£¬ÒÔºó»áÉٺܶàÂé·³¡£
PHP·¢Õ¹Á˲»ÉÙ£¬ÏÖÔÚpearÓÃÆðÀ´ºÜ·½±ã£¬ÆäÖоÍÓÐÏà¹ØµÄclassÀ´¶ÁÈ¡ExcelÎļþÀïÃæµÄÄÚÈÝ£¬Èç¹û²»ÏëʹÓÃpearµÄ»°£¬¿ÉÒÔ¿¼ÂÇʹÓÃexcel_class.php£¬googleһϣ¬¿ÉÒÔÕÒµ½Õâ¸öclassµÄsource codeÏÂÔØ£¬Ò²ÄÜÕÒµ½»ù±¾µÄexample c ......