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

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ÎÊÌâ

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

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

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

MYSQL°²×°Ê§°Ü

ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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µÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysqlÂýÈÕÖ¾ÎÊÌâ

hi,
ÔÚÅäÖÃÎļþÖÐÅäÖÃÁËÂýÈÕÖ¾£¬µ«Êǵ½Ä¿±êÎļþ¼Ðϲ鿴ȴûÓУ¬ÇëÎÊÄÄÀï³öÎÊÌâÁË

1.ÅäÖÃÎļþ
log-slow-queries="D:/mysql/slowlog"
long_query_time=0.01
log-queries-not-using-inde ......

MYSQL´æ´¢¹ý³Ìµ÷ÓòÎÊýµÄÎÊÌâ

Ö±½ÓÉÏ´úÂë°É
VB code:

Option Explicit
Private Sub Command1_Click()

Dim MyComm As New ADODB.Command
Dim Rs_GetList As New ADODB.Recordset

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