¹ØÓÚ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 »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......