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

ÇómysqlÓï¾ä - PHP / »ù´¡±à³Ì

ÓÐÕâÑùÁ½Õűí

volume ¾ç±¾·Ö¾í±í

×ֶΠעÊÍ
volid ·Ö¾íID
title ·Ö¾íÃû³Æ
dateline ·¢²¼Ê±¼ä

section ¾ç±¾Õ½ڱí

×ֶΠעÊÍ
secid Õ½ÚID
volid ·Ö¾íID
subject Õ½ڱêÌâ
dateline ¸üÐÂʱ¼ä

ÎÒÏëÏȲéѯ³ö·Ö¾í£¬È»ºóÿ¸ö·Ö¾íÖж¼ÏÔʾ×îеÄÒ»¸öÕ½ڣ¬ÓÃÒ»¾äsqlÓï¾äÔõôʵÏÖ£¿
SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid
ÓÃleft join Äܲ»ÄÜʵÏÖ½µÐòµÄ£¿
µ±È»¿ÉÒÔ£¬Ö±½Ó¸úÉÏ ORDER BY volid DESC//»»³ÉÄãÏëÒªµÄ¾ÍÊÇ£¬Ò»ÑùµÄ°¡

ÒýÓÃ
µ±È»¿ÉÒÔ£¬Ö±½Ó¸úÉÏ ORDER BY volid DESC//»»³ÉÄãÏëÒªµÄ¾ÍÊÇ£¬Ò»ÑùµÄ°¡


SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid
ORDER BY s.dateline WHERE v.volid>2 DESC ORDER BY v.dateline DESC

ÕâÑù£¿ ÕâÑù±¨´íµÄ

ÒýÓÃ
µ±È»¿ÉÒÔ£¬Ö±½Ó¸úÉÏ ORDER BY volid DESC//»»³ÉÄãÏëÒªµÄ¾ÍÊÇ£¬Ò»ÑùµÄ°¡


SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid
ORDER BY s.dateline DESC WHERE v.volid>2 ORDER BY v.dateline DESC

ÕâÑù£¿ ÕâÑù±¨´íµÄ

SQL code:
SELECT v.*,s.subject from volume v LEFT JOIN section s ON s.volid=v.volid WHERE v.volid>2 ORDER BY v.dateline DESC


ÒýÓÃ
SQL code
SEL


Ïà¹ØÎÊ´ð£º

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

php¸újspÖ®¼äsession¹²ÏíµÄÎÊÌâ - Java / Web ¿ª·¢

×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔ­ÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬Ô­À´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......

mysqlÎÊÌ⣡ - Java / Java SE

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

php session ¶ªÊ§ - PHP / »ù´¡±à³Ì

ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,Ô­À´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁË°É£¬¿ÉÒÔ¿´¿´

cookie Æ ......

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

ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ­°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ