MYSQLÊý¾ÝµÄ¼ìË÷ЧÂÊ
ÓÐÕâôһ×éÊý¾Ý AA00000,AA00001,AA00002......AA99999 BB00000,BB00001,BB00002......BB99999 CC00000,CC00001,CC00002......CC99999 . . . . ZZ00000,ZZ00001,ZZ00002......ZZ99999 Èç¹û¶ÔÆä×öSELECT£¬ÒòΪÊý¾ÝÁ¿½Ï´ó£¬Î´±ØÊÇ7룬¿ÉÄÜ8λ9λµÄ¡£ ÊÇÖ±½Ó¾ÍÕâôһ¸öÁмÈ룬»¹ÊǷֶΣ¨Àý£ºFTotal:AA00000,FRev:AA,FNum:00000£©È»ºóselect.....whereЧÂʸßÐ©ÄØ£¿»òÕßÓÐÆäËû¸üºÃµÄ°ì·¨ÄØ£¿
û¿´¶®ÐèÇó¡£ ÄãÊÇÊäÈëÊý¾Ý»¹ÊDzéѯÊý¾Ý£¿ÒýÓà û¿´¶®ÐèÇó¡£ ±ÈÈç˵£º Á½¸öÊý¾Ý£º ¡°ÎÒÊÇ»ÒÌ«ÀÇ¡± ¡°ÎÒÊÇϲÑòÑò¡± Èç¹ûÓиö100WÌõ¡°ÎÒÊÇ...¡±µÄÊý¾Ý£¬ ÎÒÒª¶ÔËûÃÇ×öSELECT£¨ÀýÈçSELECTÎÒÊÇϲÑòÑò£©£¬ÊÇÖ±½Ó¾ÍÉèÖÃÒ»ÁУº FIAM ÎÒÊÇ»ÒÌ«ÀÇ ÎÒÊÇϲÑòÑò ÄãÊǺìÌ«ÀÇ SELECT FIAM from TABLENAME where FIAM ='ÎÒÊÇϲÑòÑò' »òÕßÉ趨¶àÁУ¬·Ö¶à¸öwhere SELECTЧÂÊ¸ß FIAM(P Key) FMY FIS ÎÒÊÇ»ÒÌ«ÀÇ ÎÒÊÇ »ÒÌ«ÀÇ ÎÒÊÇϲÑòÑò ÎÒÊÇ Ï²ÑòÑò ÄãÊǺìÌ«ÀÇ ÄãÊÇ ºìÌ«ÀÇ select FIAM from TABLENAME where FMY='ÎÒÊÇ' and FIS='ϲÑòÑò' ÒýÓà ÄãÊÇÊäÈëÊý¾Ý»¹ÊDzéѯÊý¾Ý£¿ ÏȲéѯ£¨Êý¾ÝÁ¿Ó¦¸Ã¹ý10e9£©£¬Ã»ÓÐÄǸöÖµ¾ÍÊäÈ룬ÓÐÔòÌø¹
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺 <?php $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error()); & ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
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. ......
ÈçÌâ, ÎÒдÁËÒ»¸öevent schedule,ûÓÐÆð×÷ÓÃ,ҲûÓÐÈκγö´íÐÅÏ¢,´úÂëÈçÏ delimiter | create event myevent on schedule every 2 second starts current_timestamp ends curre ......
¼ÙÉèÎÒÓÐÒ»ÕűíA Á½¸ö×Ö¶ÎID date 1 2009-10-10 11:11:11 2 2009-10-10 11:11:13 3 2009-10-10 11:11:15 4 2009-10-10 11:11:17 »¹ÓÐÒ»ÕűíB Èý¸ö×Ö¶ÎID A_id date 1 1 2009-10 ......