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½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id' idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£ Ìù³öÄãµÄ create table Óï¾ä£¬¼°ÄãµÄmysql °æ±¾¡£ µ±ÄúµÄÎÊ ......
Java code: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was51093 seconds ago.The last packet sent successfully to the server was 5 ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë ÀýÈ磺 SELECT time, goodid from dbname1.time, dbname2.goods ÊÇÕâ¸öÒâ˼ô£¿ SELECT time, goodid from ......
id name datetime 1 a 2010-05-13 10:15:00 2 b 2010-05-14 09:10:00 3 d 2010-05-14 10:10:00 ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ Ð»Ð»¿© °¡ ºÇºÇ update table_n ......