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£©£¬Ã»ÓÐÄǸöÖµ¾ÍÊäÈ룬ÓÐÔòÌø¹
Ïà¹ØÎÊ´ð£º
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿ now() SQL code: sqlÀïÊÇ£º getdate() ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /* ......
ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
MySQLÈëÃÅ ¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿ ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£ È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html ¾ÍÕÒÒ»±¾ºÜ»ù´ ......
hi, ÔÚÅäÖÃÎļþÖÐÅäÖÃÁËÂýÈÕÖ¾£¬µ«Êǵ½Ä¿±êÎļþ¼Ðϲ鿴ȴûÓУ¬ÇëÎÊÄÄÀï³öÎÊÌâÁË 1.ÅäÖÃÎļþ log-slow-queries="D:/mysql/slowlog" long_query_time=0.01 log-queries-not-using-inde ......
Ö±½ÓÉÏ´úÂë°É VB code: Option Explicit Private Sub Command1_Click() Dim MyComm As New ADODB.Command Dim Rs_GetList As New ADODB.Recordset With MyComm .ActiveConn ......