Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄÅóÓѵÄÖÒ¸æ - PHP / ¿ªÔ´×ÊÔ´

ĿǰÔÚÎ人ÕÒ¹¤×÷  
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......

phpÎļþÉÏ´«³öÀ´µÄ¼¸¸öСÎÊÌâ - PHP / ¿ªÔ´×ÊÔ´

ÎÒÓÃphpÎļþÉÏ´«
ʹÓÃmove_upload_file()£¬
Ò»ÉÏ´«Îļþ¾Í³ö´íÁË£¬
³ö´íµÄÐÅÏ¢ÊÇ
Warning: move_uploaded_file(F:\Server\www\): failed to open stream: Permission denied in F:\Server\www\eoool\finish\uploa ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ