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

MySQL¿Í»§¶ËÔ¶³ÌÁ¬½Ó1045µÄ´íÎó

×î½üÐèҪʹÓÃMySQL£¬Ö»ºÃ¸Ï½ôѧϰһÏ¡£ÄÄÀïÖªµÀµÚÒ»²½¾Í¿¨×¡ÁË¡£×°ÁËÒ»¸ö¿Í»§¶Ë£¬Á¬²»ÉÏ£¬±¨1045µÄ´íÎó¡£
´ÓÍøÉÏÕÒÁËһϣ¬Èý²½¾ÍºÃ¡£
INSERT INTO `user` VALUES ('%','root','*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
GRANT ALL PRIVILEGES ON *.* TO root@"%";
FLUSH PRIVILEGES;
µÚÒ»²½ÎҸijÉinsertÁË¡£
»¹ÓоÍÊǶÔMySQL²»ÊìϤ£¬²»ÖªµÀÕâ¸öUSER±íµÄ¾ßÌåÓ÷¨£¬¾ÍÏȵ¼³öÀ´£¬¸´ÖÆÁËÒ»Ìõ¡£
µ¼³öµ¹ÊǺܷ½±ã£º
# mysqldump -uroot -ppass mysql > mysql.sql


Ïà¹ØÎĵµ£º

¶ÔmysqlµÄorder by¼°limitÓÅ»¯ÒªÊÊÊý¾ÝÇé¿ö¶ø¶¨

ÒÔÏÂÕâÆªÎÄÕÂÂÛÊöÉÏÔÚʲôÇé¿öÏÂ×Ó²éѯ±ÈÒ»°ãµÄÄÚÁ¬½Ó²éѯ¸ü¼Ó¿ìËÙ
http://www.mysqlperformanceblog.com/2010/03/18/when-the-subselect-runs-faster/
ÒÔÏÂÊÇÎÒ¶ÔmysqlµÄorder byºÍlimitÓÅ»¯µÄ½¨Ò飬ҪÊʱíµÄÊý¾ÝÁ¿ºÍÓÃÀ´¹ýÂËÁеÄΨһֵµÄ¸öÊý¶ø¶¨
£¨1£©where×Ó¾äÖÐÓÃÀ´¹ýÂ˽á¹ûµÄÁÐËùÔÚË÷ÒýµÄcadinalityºÜС£¬¼´ÓÃÏà¹Ø ......

windows7ϰ²×°apache+php+mysqlÎÊÌâ¼Ç¼

×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃæ£¬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØÐ°²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......

mysql Êý¾Ýͬ²½

  Êý¾Ýͬ²½ÎÊÌâÖÕÓÚ½â¾ö£º
תÌû£ºA·þÎñÆ÷£º host 192.168.1.101 port 3306 B·þÎñÆ÷£º host 192.168.1.102 port 3306 1,ÊÚȨÓû§£º A·þÎñÆ÷ mysql>grant replication slave,file on *.* to 'repl9'@'192.168.1.102' identified by '1234569'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Qu ......

mysql gui tools ʹÓÃ

¸Õ¿ªÊ¼²Ù×÷Êý¾Ý¿âʱÎÒÒ»°ãÊDz»Ê¹ÓÃʲôgui¹¤¾ßµÄ£¬ÎÒÊÇÖ±½ÓʹÓÃcmdϲÙ×÷µÄ£¬¸Ð¾õÓÃÆðÀ´Ò²Í¦²»´íµÄ¡£
×î½ü¿´µ½ÓÐgui¹¤¾ßÄÇÒ²²»´í°¡£¬¾ÍÏÂÀ´Ê¹ÓÃһϣ¬ÎÒϲ»¶ÏµÄÊÇѹËõ°üÃâ°²×°µÄ£¬ÕâÑù¸Ð¾õ±È½ÏÊæ·þ°¡
´ò¿ª²éѯ¹¤¾ßÊǾ¹È»³ö´íÁË£¬²»¹ýÄÜÕý³£Ê¹Óõ쬵±Ê±Ò²Ã»ÓÐ×¢Ò⣬½ñÌìÌØÒâµÄ¿´ÁËÒ»ÏÂ
Ó¦¸ÃÊÇmysqlqb_functions.xml¼ÓÔØ ......

MySQL³£Óú¯Êý

Ò»¡¢Êýѧº¯Êý
ABS(x)                    ·µ»ØxµÄ¾ø¶ÔÖµ
BIN(x)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·µ»ØxµÄ¶þ½øÖÆ£¨OCT·µ»Ø°Ë½øÖÆ£¬HEX·µ»ØÊ®Áù½øÖÆ£©
CEILING(x)            ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ