mysqlÄÚ´æÓ³Éä
Ï뽫mysqlÒ»¸öÊý¾Ý¿âÉϵÄһЩ±íÓ³Éäµ½Äڴ棬ÒÔÌá¸ß·ÃÎÊËÙ¶È¡£¶øÇÒÕâЩ±í»áÓвåÈ롢ɾ³ýºÍ¸üеIJÙ×÷¡£ ÔÚmysqlÉÏÔõô×ö£¿ÄÜ·ñ¾ßÌå˵Ã÷Ôõô×ö£¿
mysql ĬÈϾÍÊÇ´ÓÄÚ´æÖжÁÈ¡±íÊý¾Ý½øÐвÙ×÷µÄ°¡ ÓÅ»¯²éѯËÙ¶È 1.¸ü¸ÄϵͳÐÔÄÜ 2.¸ù¾ÝÐèÇóÐÞ¸Ämy.iniÅäÖà 3.ÓÅ»¯²éѯ¡¢²åÈëµÈÓï¾ä Ó¦¸ÃûÓÐÂ¥ÉÏ˵µÄÄÇô¼òµ¥°É£¬Ä¬ÈϾÍÊÇ´ÓÄÚ´æÖжÁÈ¡±íÊý¾Ý½øÐвÙ×÷µÄ£¿²¢²»Äܱ£Ö¤100£¥ÊÇ´ÓÄÚ´æÖжÁÈ¡µÄ°É£¬Òª²»Ôõô»¹ÒªÊ²Ã´ÄÚ´æ±í¸Éʲô£¿ µÄÈ·ÊÇ mysqlÓиöÏÞÖÆµÄkey_buffer_size read_buffer_size µ±Êý¾ÝÁ¿´óÓÚ¸ÃÖµµÄʱºò mysqlÓÃÁÙʱ±í½øÐзâ×°Êý¾Ý ËùÒÔÖ»Òª½øÐÐÏàÓ¦µÄÉèÖþͿÉÒÔÈÃËüÔÚÄÚ´æÖжÁÈ¡Êý¾Ý µ«ÊDz»ÊÇËùÓÐÇé¿ö¶¼ÐÐµÄ ÒýÓà µÄÈ·ÊÇ mysqlÓиöÏÞÖÆµÄkey_buffer_size read_buffer_size µ±Êý¾ÝÁ¿´óÓÚ¸ÃÖµµÄʱºò mysqlÓÃÁÙʱ±í½øÐзâ×°Êý¾Ý ËùÒÔÖ»Òª½øÐÐÏàÓ¦µÄÉèÖþͿÉÒÔÈÃËüÔÚÄÚ´æÖжÁÈ¡Êý¾Ý µ«ÊDz»ÊÇËùÓÐÇé¿ö¶¼ÐÐµÄ °æÖ÷¿´¿´ÔÚÕâ¸ö˵µÄ¶Ô²» ¼Ç²»ÇåÁË ¾ÀÕýÏ ÄÇÈç¹ûʹÓÃHEAP´æ´¢ÒýÇæµÄ»°£¬ÊDz»ÊÇ˵ÎÒÐèÒªÒ»¸öÔʼÊý¾Ý±í£¬Ò»¸öHEAPÀàÐ͵ıí ÿ´ÎÔʼÊý¾ÝµÄ±íÓиüУ¬»¹ÐèÒª½¨Á¢´¥·¢Æ÷È¥¸üÐÂHEAP±í£¿ ÓÐûÓиü¾ßÌåµÄ²Ù×÷½éÉÜ£¿ »¹ÓУ¬ÎÒ¿´NDB Cluster´æ´¢ÒýÇæ½éÉܵÄʱºò£¬ËµÕâ¸öÊÇÄÚ´æÊ½µÄ´æ´¢ÒýÇæ£¬ÄÇÊÇ·ñ¾Í²»ÐèÒª×öÄÚ´æÓ³ÉäÁËÄØ£¿
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿ now() SQL code: sqlÀïÊÇ£º getdate() ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /* ......
SQL code: --½¨Á¢ÁÙʱ±í£¬ÎÊÌâ1 create TEMPORARY table tmp_table(s1 int,s2 varchar(30)) --select * from tmp_table --½¨Á¢ÁÙʱ±äÁ¿£¬ÎÊÌâ2 set @v=0; --Ñ»·Ö´ÐвåÈë²Ù×÷£¬ÎÊÌâ3 while @v<20 do ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from ( SELECT tg.tguildname,c.cid, ( cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
mysql£º ·þÎñÆ÷: Localhost via UNIX socket ·þÎñÆ÷°æ±¾: 5.1.33-log ÐÒé°æ±¾: 10 Óû§: root@localhost MySQL ×Ö·û¼¯: UTF-8 Unicode (utf8) ´íÎó£º SQL ²éѯ: CREATE TABLE ......