Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

myeclipse+mysqlµÄÅäÖÃÎÊÌâ - Java / Eclipse

ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ­°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......

mysqlÍâ¼ü - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb

貼³öSQL&# ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ