mysqlÈçºÎ°ÑÔÚÆÁÄ»ÉÏÊä³öµÄ½á¹ûÊä³öµ½Ò»¸öÎļþÉÏ£¿
show profile cpu, block io for query 15 µÄ½á¹ûÌ«´ó£¬Ò»ÆÁÄ»×°²»Ï£¬Ï뽫½á¹ûÊä³öµ½Ò»¸öÎļþÉÏÔÙ¿´£¡
ûÓÐʲôºÃ°ì·¨£¬mysql.exe ±¾ÉíûÓУϣңÁ£Ã£Ì£ÅÄÇÖÖspool µÄÃüÁî¡£Èç¹ûÊǣףɣģΣϣףӣ¬ÔòÔÚËüµÄÃüÁîÐй¤¾ßµÄÊôÐÔÖаѣ£գƣƣţÒÉèÖøßһЩ¡£ Èç¹ûÊǣգΣɣØÖ®ÀàµÄ£¬µ¹ÊÇ¿ÉÒÔÓÃһЩtelnet µÄ¹¤¾ß±¾ÉíÓмǼ¹¦ÄÜ¡£ Ö»ÓÐCOPY¡¢PASTE£¬Ã»Óа취 SQL code: D:\>mysql -uroot -p -e "show profile cpu, block io for query 15" > e:\aa.txt Enter password: D:\> linuxÏÂÒ²¿ÉÒÔÓÃÀàËÆÉÏÃæµÄshellÃüÁî·½·¨ ÈýÂ¥·½·¨²»´í£¬Ö±½ÓÖØ¶¨Ïò¡£ ¿ÉÊÇÔÚÒ»¸ösessionÖÐÎÒ±ØÐëÏÈÖ´ÐÐ set profiling=1ºÍÎÒÒª²âÊÔµÄsql£¬Ö®ºó²ÅÄÜÖ´ÐÐshow profile cpu, block io for query 15 ǰ±ßµÄÁ½ÌõÓï¾äÒªÈçºÎÖ´ÐÐÄØ£¿ show profile cpu, block io for query 15 ÔõôÓà ѧϰÖÐ... D:\>mysql -uroot -p -e "select * from test ; show profile cpu, block io for query 15" > e:\aa.txt Äã¿ÉÒ԰Ѷà¸öÓï¾ä·Åµ½ÆäÖС£ËäÈ»²»·½±ã¡£ ¿ÉÒÔ into outfile ô¡£¡£¡£ÎÒ¾³£ÓÃoutfileµ¼³ö±íÀïij¸ö×ֶεIJéѯ½á¹û ÒýÓà D:\>mysql -uroot -p -e "select * from test ; show profile cpu, block io for query 15" > e:\aa.txt Äã¿ÉÒ԰Ѷà¸öÓï¾ä·Åµ½ÆäÖС£ËäÈ»²»·½±ã¡£ ÈçÐèÒªÔĶÁ
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓᣠÊý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿ now() SQL code: sqlÀïÊÇ£º getdate() ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /* ......
MySQLÈëÃÅ ¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿ ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£ È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html ¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12 £¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......