¹ØÓÚMYSQLÖÐÈ¡³öʱ¼äÁÐÎÊÌâ
ÔÚMQSQLÊý¾Ý¿âÖУ¬ÎÒÓÐÒ»¸ö±íÀï´æ·ÅÁË'2009-12-23'ÕâÖÖ¸ñʽµÄÈÕÆÚÊý¾Ý£¬ÎÒÊÇÒÔvarcharÀàÐͽøÐб£´æµÄ£¬¶øÇÒÊÇÒ»Ìì±£´æÒ»´Î£¬ËùÒÔÈÕÆÚ¶¼ÊÇÒ»ÌìµØÔö¼Ó£¬ÎÒÏÖÔÚҪÿ¸ôÁ½ÌìÈ¡³öÒ»´ÎÊý¾Ý£¬Ò²¾ÍÊÇÈ¡³öÊý¾ÝΪ'2009-12-23','2009-12-25','2009-12-27'£¬ÇëÎÊҪȡ³öÕâÑùµÄÊý¾ÝÔõôдsql°¡
sf ²»»á sql°æÎ桃 ÕÒÕÒdateÀàÐ͵ÄÊý¾Ý¿âº¯Êý mysql ÈÕÆÚº¯Êý¿ÉÒÔ×ö¡£ÓÐÈÕÆÚ¼Ó¼¸ÌìµÄº¯Êý¡£ÒýÓà ÏȽصô¡°-¡±ÔÙ½«Õû¸ö×Ö·û´®×ªÎªÕûÐÍ£¬È»ºó¾ÍÊÇÒ»¸öºÜ¼òµ¥µÄÊýѧÌâÁË£¬select * from table where (date-starDate)%2=0£¬ÕâÀïµÄdateÊÇÒѾתÁËÕûÊýµÄ£¬¼õÈ¥ÆðʼÈÕÆÚµÄÕûÊýֵģ2Èç¹ûµÈÓÚ0¾ÍÊÇÄãÏëÒªµÄÁË¡£ .
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂ𣿠Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡ ²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â 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: ......