ÔÚPHPÖÐÈ«Ãæ×èÖ¹SQL×¢Èëʽ¹¥»÷Ö®Ò»
Ò»¡¢ ÒýÑÔ
¡¡¡¡PHPÊÇÒ»ÖÖÁ¦Á¿Ç¿´óµ«Ï൱ÈÝÒ×ѧϰµÄ·þÎñÆ÷¶Ë½Å±¾ÓïÑÔ£¬¼´Ê¹ÊǾÑé²»¶àµÄ³ÌÐòÔ±Ò²Äܹ»Ê¹ÓÃËüÀ´´´½¨¸´ÔӵĶ¯Ì¬µÄwebÕ¾µã¡£È»¶ø£¬ËüÔÚʵÏÖÒòÌØÍø·þÎñµÄÃØÃܺͰ²È«·½ÃæÈ´³£³£´æÔÚÐí¶àÀ§ÄÑ¡£ÔÚ±¾ÏµÁÐÎÄÕÂÖУ¬ÎÒÃǽ«Ïò¶ÁÕß½éÉܽøÐÐweb¿ª·¢Ëù±ØÐèµÄ°²È«±³¾°ÒÔ¼°PHPÌض¨µÄ֪ʶºÍ´úÂë-Äã¿ÉÒÔ½èÒÔ±£»¤Äã×Ô¼ºµÄwebÓ¦ÓóÌÐòµÄ°²È«ÐÔºÍÒ»ÖÂÐÔ¡£Ê×ÏÈ£¬ÎÒÃǼòµ¥µØ»Ø¹ËһϷþÎñÆ÷°²È«ÎÊÌâ-չʾÄãÈçºÎ´æÈ¡Ò»¸ö¹²ÏíËÞÖ÷»·¾³ÏµÄ˽ÈËÐÅÏ¢£¬Ê¹¿ª·¢ÕßÍÑÀ뿪Éú²ú·þÎñÆ÷£¬Î¬³Ö×îеÄÈí¼þ£¬Ìṩ¼ÓÃܵÄƵµÀ£¬²¢ÇÒ¿ØÖƶÔÄãµÄϵͳµÄ´æÈ¡¡£
¡¡¡¡È»ºó£¬ÎÒÃÇÌÖÂÛPHP½Å±¾ÊµÏÖÖеÄÆÕ±é´æÔڵĴàÈõÐÔ¡£ÎÒÃǽ«½âÊÍÈçºÎ±£»¤ÄãµÄ½Å±¾ÃâÓÚSQL×¢È룬·ÀÖ¹¿çÕ¾µã½Å±¾»¯ºÍÔ¶³ÌÖ´ÐУ¬²¢ÇÒ×èÖ¹¶ÔÁÙʱÎļþ¼°»á»°µÄ"½Ù³Ö"¡£
¡¡¡¡ÔÚ×îºóһƪÖУ¬ÎÒÃǽ«ÊµÏÖÒ»¸ö°²È«µÄWebÓ¦ÓóÌÐò¡£Ä㽫ѧϰÈçºÎÑéÖ¤Óû§Éí·Ý£¬ÊÚȨ²¢¸ú×ÙÓ¦ÓóÌÐòʹÓ㬱ÜÃâÊý¾ÝËðʧ£¬°²È«µØÖ´Ðи߷çÏÕÐÔµÄϵͳÃüÁ²¢Äܹ»°²È«µØʹÓÃweb·þÎñ¡£ÎÞÂÛÄãÊÇ·ñÓÐ×ã¹»µÄPHP°²È«¿ª·¢¾Ñ飬±¾ÏµÁÐÎÄÕ¶¼»áÌṩ·á¸»µÄÐÅÏ¢À´°ïÖúÄã¹¹½¨¸üΪ°²È«µÄÔÚÏßÓ¦ÓóÌÐò¡£
¡¡¡¡¶þ¡¢ ʲôÊÇSQL×¢Èë
¡¡¡¡Èç¹ûÄã´òËãÓÀÔ¶²»Ê¹ÓÃijЩÊý¾ÝµÄ»°£¬ÄÇô°ÑËüÃÇ´æ´¢ÓÚÒ»¸öÊý¾Ý¿âÊǺÁÎÞÒâÒåµÄ£»ÒòΪÊý¾Ý¿âµÄÉè¼ÆÄ¿µÄÊÇΪÁË·½±ãµØ´æÈ¡ºÍ²Ù×÷Êý¾Ý¿âÖеÄÊý¾Ý¡£µ«ÊÇ£¬Èç¹ûÖ»ÊǼòµ¥µØÕâÑù×öÔòÓпÉÄܻᵼÖÂDZÔÚµÄÔÖÄÑ¡£ÕâÖÖÇé¿ö²¢²»Ö÷ÒªÊÇÒòΪÄã×Ô¼º¿ÉÄÜżȻɾ³ýÊý¾Ý¿âÖеÄÒ»ÇУ»¶øÊÇÒòΪ£¬µ±ÄãÊÔͼÍê³ÉijÏî"ÎÞ¹¼"µÄÈÎÎñʱ£¬ÄãÓпÉÄܱ»Ä³Ð©ÈËËù"½Ù³Ö"-ʹÓÃËû×Ô¼ºµÄÆÆ»µÐÔÊý¾ÝÀ´È¡´úÄã×Ô¼ºµÄÊý¾Ý¡£ÎÒÃdzÆÕâÖÖÈ¡´úΪ"×¢Èë"¡£
¡¡¡¡Æäʵ£¬Ã¿µ±ÄãÒªÇóÓû§ÊäÈë¹¹ÔìÒ»¸öÊý¾Ý¿â²éѯ£¬ÄãÊÇÔÚÔÊÐí¸ÃÓû§²ÎÓë¹¹½¨Ò»¸ö´æÈ¡Êý¾Ý¿â·þÎñÆ÷µÄÃüÁһλÓѺõÄÓû§¿ÉÄܶÔʵÏÖÕâÑùµÄ²Ù×÷¸Ð¾õºÜÂúÒ⣻Ȼ¶ø£¬Ò»Î»¶ñÒâµÄÓû§½«»áÊÔͼ·¢ÏÖÒ»ÖÖ·½·¨À´Å¤Çú¸ÃÃüÁ´Ó¶øµ¼Ö¸ñ»µÄŤÇúÃüÁîɾ³ýÊý¾Ý£¬ÉõÖÁ×ö³ö¸üΪΣÏÕµÄÊÂÇé¡£×÷Ϊһ¸ö³ÌÐòÔ±£¬ÄãµÄÈÎÎñÊÇÑ°ÕÒÒ»ÖÖ·½·¨À´±ÜÃâÕâÑùµÄ¶ñÒâ¹¥»÷¡£
¡¡¡¡Èý¡¢ SQL×¢È빤×÷ÔÀí
¡¡¡¡¹¹ÔìÒ»¸öÊý¾Ý¿â²éѯÊÇÒ»¸ö·Ç³£Ö±½ÓµÄ¹ý³Ì¡£µäÐ͵أ¬Ëü»á×ñÑÈçÏÂ˼·À´ÊµÏÖ¡£½öΪ˵Ã÷ÎÊÌ⣬ÎÒÃǽ«¼Ù¶¨ÄãÓÐÒ»¸öÆÏÌѾÆÊý¾Ý¿â±í¸ñ"wines"£¬ÆäÖÐÓÐÒ»¸ö×Ö¶ÎΪ"variety"£¨¼´ÆÏÌѾÆÀàÐÍ£©£º
¡¡¡¡1. Ìṩһ¸ö±íµ¥-ÔÊÐíÓû§ÌύijЩҪËÑË÷µÄÄÚÈÝ¡£ÈÃÎÒÃǼٶ¨Óû§Ñ¡ÔñËÑË÷ÀàÐÍΪ"lagrein"µÄÆÏÌѾơ£
¡¡¡¡2. ¼ìË÷¸ÃÓû§µÄËÑË÷ÊõÓ²¢ÇÒ±£´æËü-ͨ¹ý°ÑËü¸³¸øÒ»¸öÈçÏÂË
Ïà¹ØÎĵµ£º
1 ÔÚSQLÓï¾äÖпÉͨ¹ýÌí¼ÓÏÞÖÆÌõ¼þ:left(text,20)ֻȡtextÎı¾µÄÇ°20¸ö×Ö;
¡¡¡¡2 ¿ÉÒÔÓÃlimit fromRecord, RecordNum À´×÷Ϊ·ÖҳʹÓÃ,±ÈÈçlimit 0,30±íʾ´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼±éÀú30¸ö¼Í¼;
¡¡¡¡3 Á½¸ö±íµÄÁ¬½Ó¿ÉÒÔÊÇ£ºtable1 join table2 using x(xΪÁ½¸ö±íµÄ¹«¹²×Ö¶Î),»òÕßÊÇtable1 join table2 on table1.x = table2.x
¡¡¡ ......
HTML:
<META HTTP-EQUIV="pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate">
<META HTTP-EQUIV="expires" CONTENT="Wed, 26 Feb 1997 08:21:57 GMT">
<META HTTP-EQUIV="expires" CONTENT="0">
PHP£º
header("Expires: Mon, 26 Jul 1997 ......
Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü
ÉÏһƪ / ÏÂһƪ 2008-09-04 11:25:01
²é¿´( 1991 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_ ......
SQLÓï¾äÓÅ»¯Êµ¼ùÖ®Ò»SQL_TRACE
»·¾³£ºÔÚPL/sqlÉϵ÷ÊÔÊý¾Ý
Pl/sql developer¹¤¾ßÁ¬½ÓʵÀýºó¼´×÷Ϊһ¸öÓû§½ø³ÌÕ¼ÓÃÒ»¸ösession£»
select * from v$session t where t.PROGRAM='plsqldev.exe' and t.USERNAME='DZJC'
²éѯ½á¹ûÏÔʾÁ˼¸¸ö¹Ø¼üµÄ×Ö¶Î
SADDR RAW(4) S ......
1
¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select
*
from
people
where
peopleId
in
(
select
peopleId
from
people
group
by
peopleId
having
cou ......