¹ØÓÚ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
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
¶Ôphp²»ÊǺÜÁ˽â дÁ˸ö¼òµ¥µÄÀý×Ó ÏÖÓÃc#µ÷ÓÃphpдµÄ webservice£¨soap WSDL£©iis6.0+php5.2.8 webserviceÈçÏ <?php class WebService { public function Logout() { //header('Co ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......