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

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


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

mysql½¨±í´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÓÃmysql½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id'
idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£
Ìù³öÄãµÄ create table Óï¾ä£¬¼°ÄãµÄmysql °æ±¾¡£

µ±ÄúµÄÎÊ ......

MYSQLÁ¬½ÓµÄÎÊÌâ - Java / Java SE

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 ......

mysqlÔËÓÃÎÊÌâ - PHP / »ù´¡±à³Ì

phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿

SELECT time, goodid from ......

mysqlµÄ¸üÐÂÓï¾ä - Java / Java SE

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ