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

¹ØÓÚ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¾ÍÊÇÄãÏëÒªµÄÁË¡£

.


Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

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

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

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ