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

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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MYSQLÐÂÊÖÎÊÌ⣬

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
......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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±íÃû²»Äܳ¬¹ý6¸ö×Ö½Ú

mysql£º
·þÎñÆ÷: Localhost via UNIX socket
·þÎñÆ÷°æ±¾: 5.1.33-log
ЭÒé°æ±¾: 10
Óû§: root@localhost
MySQL ×Ö·û¼¯: UTF-8 Unicode (utf8)


´íÎó£º
SQL ²éѯ:

CREATE TABLE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ