phpÖÐsqlÓï¾äµÄÒýºÅÏê½â
Õâ¾ÍÒª´ÓË«ÒýºÅºÍµ¥ÒýºÅµÄ×÷Óý²Æð£º
Ë«ÒýºÅÀïÃæµÄ×ֶλᾹý±àÒëÆ÷½âÊÍÈ»ºóÔÙµ±×÷HTML´úÂëÊä³ö£¬µ«Êǵ¥ÒýºÅÀïÃæµÄ²»ÐèÒª½âÊÍ£¬Ö±½ÓÊä³ö¡£ÀýÈ磺
$abc='I love u';
echo $abc //½á¹ûÊÇ:I love u
echo '$abc' //½á¹ûÊÇ:$abc
echo "$abc" //½á¹ûÊÇ:I love u
ËùÒÔÔÚ¶ÔÊý¾Ý¿âÀïÃæµÄSQLÓï¾ä¸³ÖµµÄʱºòÒ²ÒªÓÃÔÚË«ÒýºÅÀïÃæSQL="select a,b,c from ..."
µ«ÊÇSQLÓï¾äÖлáÓе¥ÒýºÅ°Ñ×Ö¶ÎÃûÒý³öÀ´
ÀýÈç:select * from table where user='abc';
ÕâÀïµÄSQLÓï¾ä¿ÉÒÔÖ±½Óд³ÉSQL="select * from table where user='abc'"
µ«ÊÇÈç¹ûÏóÏÂÃ棺
$user='abc';
SQL1="select * from table where user=' ".$user." ' ";¶Ô±ÈÒ»ÏÂ
SQL2="select * from table where user=' abc ' "
ÎҰѵ¥ÒýºÅºÍË«ÒýºÅÖ®¼ä¶à¼ÓÁ˵ã¿Õ¸ñ£¬Ï£ÍûÄãÄÜ¿´µÄÇå³þÒ»µã¡£
Ò²¾ÍÊÇ°Ñ'abc' Ì滻Ϊ '".$user."'¶¼ÊÇÔÚÒ»¸öµ¥ÒýºÅÀïÃæµÄ¡£Ö»ÊÇ°ÑÕû¸öSQL×Ö·û´®·Ö¸îÁË¡£
SQL1¿ÉÒÔ·Ö½âΪÒÔÏÂ3¸ö²¿·Ö
1£º"select * from table where user=' "
2£º$user
3£º" ' "
×Ö·û´®Ö®¼äÓà . À´Á¬½Ó£¬ÕâÑùÄÜÃ÷°×ÁË°É¡£
Ïà¹ØÎĵµ£º
sqlÓïÑÔÖÐÓÐûÓÐÀàËÆCÓïÑÔÖеÄswitch caseµÄÓï¾ä£¿£¿
ûÓÐ,ÓÃcase when À´´úÌæ¾ÍÐÐÁË.
ÀýÈç,ÏÂÃæµÄÓï¾äÏÔʾÖÐÎÄÄêÔÂ
select getdate() as È ......
1.ÏÞÖÆ·µ»Ø¼Ç¼µÄÐÐÊý£¨4-10ÐУ©
select rownum,c1 from t144 where rownum<10
minus
select rownum,c1 from t144 where rownum<5
2.ÅúÁ¿²åÈë
insert into tablename(select * from othertable)
»ò
insert into (column1,column2,,,,,,,)tablename(select column1,column2,,,,,,,from othertable)
3,·Ö×éº¯Ê ......
SQL UNION ²Ù×÷·û
UNION ²Ù×÷·ûÓÃÓںϲ¢Á½¸ö»ò¶à¸ö SELECT Óï¾äµÄ½á¹û¼¯¡£
Çë×¢Ò⣬UNION ÄÚ²¿µÄ SELECT Óï¾ä±ØÐëÓµÓÐÏàͬÊýÁ¿µÄÁС£ÁÐÒ²±ØÐëÓµÓÐÏàËƵÄÊý¾ÝÀàÐÍ¡£Í¬Ê±£¬Ã¿Ìõ SELECT Óï¾äÖеÄÁеÄ˳Ðò±ØÐëÏàͬ¡£
SQL UNION Óï·¨
SELECT column_name(s) from table_name1
UNION
SELECT column_name(s) from table_na ......
Êý¾Ý¶¨ÒåÓïÑÔ£¨DDL£©£º
1£©´´½¨Êý¾Ý¿â£¨create£©£ºcreate database database-name;
eg. create database test;
2£©É¾³ýÊý¾Ý¿â£ºdrop database dbname;
& ......
Á¬½Ósql serverÊý¾Ý¿âÓõ½µÄÃüÃû¿Õ¼äÊÇusing System.Data.SqlClient;
Êý¾Ý¿âÁ¬½Ó´úÂë:¿ÉÒÔÔÚ´óÀàÖ®ÏÂÉùÃ÷ public SqlConnection myConnection; //sqlÁ¬½Ó¶ÔÏó
&nbs ......