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

¹ØÓÚMySQLÊý¾Ý¿âµÄ²éѯÓï¾ä

Çë´óÏÀ°ïæ¿´¿´Õâ¾äÓдíÎóÂ𣿴úÂëÈçÏ£º
SQL code:
SELECT * from test where beginTime='2009-12-20 00:00:00' and endTime='2009-12-20 23:59:59'

ΪʲôÎÒÖ´ÐÐÁËÕâ¾ä£¬È´Ã»Óнá¹ûÄØ£¿
±íµÄ½á¹¹ÈçÏ£º
id            number                phone            beginTime                endtime
1              5                  4342            2009-12-20 22:09:17        2009-12-20 22:09:23
2              23                  4543            2009-12-20 22:09:28        2009-12-20 22:09:34
3              56                  86675          2009-12-20 22:10:39        2009-12-20 22:11:52


ÄãµÄ±íÖÐÄÄÓÐÒ»Ìõ¼Ç¼µÄ beginTime='2009-12-20 00:00:00' °¡£¿

ÄãÏëʵÏÖʲô¹¦ÄÜ£¿

SQL code



Code highlighting produced by Actipro CodeHighlighter (freeware)
http


Ïà¹ØÎÊ´ð£º

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

¹ØÓÚMYSQLµÄinnodb±í±¸·ÝµÄÎÊÌâ

ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý

Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ