mysqlʱ¼ä×ֶβéѯ£¬ÔÚÏßµÈ
mysql ÖеÄʱ¼ä²éѯ£º
user±íÖÐÓÐÒ»×ֶΡ¡ModDateֵΪ¡¡2010-04-13 00:00:00¡¡ÕâÑùµÄ
ÏÖҪͨ¹ý¡¡ModDate ×ֶβ顡2010-04-13 £¨²»º¬ºóÃæµÄСʱ¡¡·Ö£©µÄ¼Ç¼
Ôõô²éѽ£¬thanks
×ֶβ»ÒªÕâÑùÖ±½Óд×Ö·û´®£¬×ª»¯Îªmysqlʱ¼ä´Á
дÈëʱ $ModDate=time();
¶Áȡʱ date("Y-m-d H:i",$ModDate) Äê-ÔÂ-ÈÕ Ê±-·Ö
date("Y-m-d",$ModDate) Äê-ÔÂ-ÈÕ
¶àл2Â¥µÄ
¿ÉÕë¶ÔÉÏÃæµÄÎÊÌ⣬ÏÖÔõô²éÄØ£¬
Èç¹ûÊDzéѯÓï¾äµÄ»°
$startTime=date("l",mktime(0,0,0,7,13,2010))); »ñµÃÒ»¸öʱ¼ä´Á
$endTime=date("l",mktime(0,0,0,7,14,2010)));
select * from ±íÃû where ModDate>$startTime and ModDate<$endTime
select * from table where ModDate LIKE 2010-04-13%;
2010-04-13 ¿ÉÒÔÔÚphp date() ´¦Àí;
£´¡¡Â¥µÄ£¬²é²»µ½¼Ç¼ѽ£¬
ModDate ӦΪ datetime ÀàÐÍ
DATE_FORMAT(ModDate,'%Y-%m-%d')='2010-04-13'
6Â¥µÄ¿ÉÒÔÁË£¬
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
×î½ü³öÏÖÒ»¸öºÜÆæ¹ÖµÄÎÊÌ⣬ÓÃADOÁ¬½ÓMYSQL£¬½«Á¬½ÓOPENµÄʱºò£¬Èç¹ûMYSQLÆô¶¯Ê±¾ÍÁ¬½Ó´íÎó£¬Í¬Ê±×Ô¶¯¹Ø±ÕMYSQL·þÎñ£»ÈôMYSQLûÓÐÆô¶¯¾Í¿ÉÒÔÕý³£OPEN¡£
Ò²¾ÍÊÇÿÁ½´ÎÔËÐбØÈ»»á³ö´íÒ»´Î£¬µ«Ã¿Á½´ÎÔËÐÐÒ²±ØÈ»³É¹¦Ò»´ ......
ͨ¹ýODBCÁ¬½ÓMySQLÊý¾Ý¿â£¬Á¬½Ó³É¹¦£¬µ«²»ÄܲéѯÊý¾Ý£¬²»ÖªµÀΪʲô
'Á¬½ÓmysqlÊý¾Ý¿â
str = "dsn=test;driver={MySQL odbc 3.51 Driver};server=localhost;port=3306;uid=root;pwd=;database=officesyst ......