mysql ²éѯÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
mysqL Óï¾ä£ºselect examlist_name as name,from_UNIXTIME(examlist_kaoshiriqi,'%Y-%m-%d') as kaoshiriqi,from_unixtime(examlist_baomingriqi '%Y-%m-%d') as baomingriqi,examlist_belong as belong from dede_examlist where examlist_kaoshiriqi>unix_timestamp()£» ²éѯµÄ½á¹ûΪ£º name kaoshiriqi baomingriqi belong µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-28 2010-05-14 zq µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-29 2010-05-14 zq µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-28 2010-05-15 zq µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-29 2010-05-15 zq µÚ¶þ´Î¿¼ÊÔ 2010-06-25 2010-06-01 zq µÚ¶þ´Î¿¼ÊÔ 2010-06-26 2010-06-01 zq µÚÈý´Î¿¼ÊÔ 2010-06-24 2010-06-18 zq µÚÈý´Î¿¼ÊÔ 2010-06-26 2010-06-18 zq µÚËĴο¼ÊÔ 2010-06-25 2010-06-19 zq µÚËĴο¼ÊÔ 2010-06-26 2010-06-19 zq µÚÎå´Î¿¼ÊÔ 2010-06-24 2010-06-12 zq µÚÎå´Î¿¼ÊÔ 2010-06-25 2010-06-12 zq µÚÎå´Î¿¼ÊÔ 2010-06-17 2010-06-10 zq µÚÎå´Î¿¼ÊÔ 2010-06-18 2010-06-10 zq µÚ°Ë´Î֤ȯ¿¼ÊÔ 2010-06-22 2010-06-12 zq µÚ°Ë´Î֤ȯ¿¼ÊÔ 2010-06-22 2010-06-13 zq µÚ¾Å´Î¿¼ÊÔ 2010-10-11 2010-10-05 zq µÚÒ»´ÎÒøÐп¼ÊÔ 2010-07-12 2010-07-11 yh µÚ¶þ´ÎÒøÐп¼ÊÔ 2010-07-22 2010-07-20 yh Õâ¸ö²éѯµÄ½á¹û£¬ÎÒÏë°Ñname ÖµÏàͬµÄ¼Ç¼£¬ºÏ²¢³ÉÒ»Ìõ¼Ç¼£¬mysql Óï¾ä¿ÉÒÔʵÏÖÂð£¿
ÒýÓà name kaoshiriqi baomingriqi belong µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-28 2010-05-14 zq µÚÒ»´Î֤ȯ¿¼ÊÔ 2010-05-29 2010-05-14 zq µÚÒ»´Î֤ȯ¿¼ÊÔ 2
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã ´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺ ½ø³ÌA ½ø³ÌB select * from user where id in lock share mode£¨¹²ÏíËø) &nb ......
ÔõôÕÒµ½Êý¾Ý¿âµÄλÖ𡣿Çë¸÷λǰ±²Ö¸½Ìһϣ¿Ð¡µÄ·Ç³£¸Ðл£¡ ÏÈÕÒµ½my.cnfÎļþ£¬´ò¿ªºó¿´[data]ϵÄdatadir 2¡¢½øÈëmysqlÖÕ¶Ë£º mysql>show variables like '%datadir%'; ÔÙ²»ÐÐÈ«ÅÌËÑË÷£º¡¡frmÎļþ
......