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

¹ØÓÚPHP+MYsql´óÁ¿Êý¾Ý´¦ÀíµÄÎÊÌâ

ÎÒÏÖÔÚÓиöÊý¾Ý¿â£¬Àï±ßÖ÷ÒªÓÐÁ½¸ö±í£¬class,news
ÏÖÔÚnews±íÓÐ2.3G£¬35W¶àÌõ¼Ç¼£¬ÎҵIJéѯ´ó²¿·ÖÊÇÒÔÏÂÐÎʽ£¬
select a.*,b.* from news as a inner join class as b
    on a.classid=b.classid
ÆÚÖÐnews ±íÀﻹÓиö nodeµÄ×ֶΣ¬Ò²Òª¼Ó½øselectÀҲ¾ÍÊÇÍêÕûµÄÊÇ
select a.*,b.* from news as a inner join class as b
    on a.classid=b.classid where classid=2 or node like '|2|%'

Ò»¸öÒ³ÃæÖÐÖÁÉÙÓÐ4¸öÕâÑùµÄ²éѯÓï¾ä£¬ÏÖÔÚ»ù±¾ÉÏ´ò²»¿ªÒ³ÃæÁË£¬ÎÒÔÚmysqlÀïÖ±½Ó²éѯҲҪ4·Ö¶àÖÓ£¬ÇëÎÊÓÐʲô°ì·¨ÄÜÓÅ»¯Ò»ÏÂÄØ£¬¿ÉÒÔ´ÓÊý¾Ý¿â»ò³ÌÐòÖж¼ÐС£µ«ÊÇÒ»¸öÎÊÌâ¾ÍÊDz»ÄÜ·Ö±íÁË£¬news ±í¼º¾­²»Äܱ䡣

²¹³äһϣ¬news ±íÖ»ÉèÖÃÁËÖ÷¼üID
1 node,classid ¼ÓË÷Òý
2 limit×Ó¾ä
3 inner join»»left join
4 ÀûÓÃExplain»ñÈ¡µÄÐÅÏ¢À´ÊµÏÖmysqlÓÅ»¯

ºÇºÇ£¬ÄÚÁ¬½ÓÕâô¶àÊý¾Ý²»Âý²Å¹ÖÁË¡£
1.½¨Á¢Ë÷Òý£¬±ÈÈçÄãµÄclassid¡£
2.Èç¹ûÄãµÄ±íÀàÐÍÊÇinnodbÄÇôÇë¸Ä³ÉMyISAM
3.ÕâÑù´óµÄÊý¾Ý²éѯ»¹ÊÇÓô洢¹ý³Ì°É£¬µÚÒ»´ÎÓеãÂý£¬µ«ÒÔºó»á¿ìºÜ¶àµÄ
4.ÖØÐ¼ܹ¹Êý¾Ý¿â

ÒýÓÃ
1 node,classid ¼ÓË÷Òý
2 limit×Ó¾ä
3 inner join»»left join
4 ÀûÓÃExplain»ñÈ¡µÄÐÅÏ¢À´ÊµÏÖmysqlÓÅ»¯
jackeyºÃ¿ìŶ

ÎÒÕâÀï±ß»¹ÓÐÁ½¸ö×ֶΣ¬Ò»¸öÊÇtop int(5)£¬Ò»¸öÊÇisdel int(5)
topÖµÊÇ0-6,isdelÖµÊÇ0 or 1
ÎÒÊDz»ÊÇÒ²½¨Á¢Ë÷Òý»áºÃÒ»µã°¡£¿
»¹ÓУ¬ÎÒÓõÄÊÇMYSQL5

¼ÈÈ»Áª±í²Ù×÷
where classid=2 or node like '|2|%'  classid


Ïà¹ØÎÊ´ð£º

¸¶·ÑÇóÒ»¶Îphp´úÂ룬֧³ÖÌÔ±¦½»Ò× - PHP / »ù´¡±à³Ì

¸÷λ´óÏÀ 
ÇóÒ»¶Îphp´úÂë 
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ 
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ 
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½ 
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ÀûÓÃPHPͨ¹ýapacheÏÂÔØwavÒôÀÖÎļþÎÞ·¨´ò¿ªÎļþ

µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔ­Òò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ