Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

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Óï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......

mysql event scheduleÎÊÌâ

ÈçÌâ, ÎÒдÁËÒ»¸öevent schedule,ûÓÐÆð×÷ÓÃ,ҲûÓÐÈκγö´íÐÅÏ¢,´úÂëÈçÏÂ

delimiter |
create event myevent  on schedule every  2 second
starts current_timestamp
ends  curre ......

mysql ²éѯµÄÎÊÌâ

¼ÙÉèÎÒÓÐÒ»Õűí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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ