sqlÅúÁ¿Ìæ»»ÌØ¶¨×Ö·û
×î½üÔÚºÍÒ»¸ö¹«Ë¾ºÏ×÷ÏîÄ¿£¬Óв¿·ÖÁ´½ÓÊÇÓÉËûÃǹ«Ë¾ÌṩµÄ£¬ÓÉÓÚµ±Ê±»¹Ã»ÓÐÉêÇëÓòÃû£¬Ö±½ÓÌṩ¸øÎÒÃǵÄÊÇipµØÖ·£¬ÏÖÔÚÕýʽÉÏÏߺó£¬ÐèÒªÎÒÃǽ«ÔÀ´µÄipµØÖ·Ì滻ΪÓòÃû£¬Èç¹ûÒ»¸ö¸öÌæ»»ÆðÀ´ÌرðÂé·³£¬¶øÇÒ¿ÉÄܳöÏÖÎÊÌ⣬Òò´ËÕÒÁËÏÂoracleÖÐsqlÅúÁ¿Ìæ»»µÄ¹¦ÄÜ£¬Ê¹ÓÃÆðÀ´Ì«·½±ãÁË£¬ÔÚÕâÀï¼Ç¼Ï£¬±ãÓÚÒÔºó²éÕÒ¡£¾ßÌåʹÓÃ˵Ã÷ÈçÏ£º
update tablename set columnName= replace(columnName,srcStr,destStr) where myField like '%srcStr%'
tablename ±íÃû
columnName ÐèÒªÌæ»»µÄ×Ö¶ÎÃû
srcStr ÐèÒª±»Ìæ»»µÄÌØ¶¨×Ö·û
destStr ÐèÒªÌæ»»³ÉµÄ×Ö·û
È磺
½«ncs_busichange_org_conf ±íÖУ¬busidetailinfo×Ö¶ÎÖеēhttp://3g.sina.com.cn/”Ìæ»»Îª£ºhttp://www.baidu.com/
sqlÈçÏ£º
update ncs_busichange_org_conf t set t.busidetailinfo=replace(busidetailinfo,'http://3g.sina.com.cn/','http://www.baidu.com/') where t.busidetailinfo like 'http://3g.sina.com.cn/%'
Ïà¹ØÎĵµ£º
Êý¾Ý¶¨ÒåÓïÑÔ£¨DDL£©£º
1£©´´½¨Êý¾Ý¿â£¨create£©£ºcreate database database-name;
eg. create database test;
2£©É¾³ýÊý¾Ý¿â£ºdrop database dbname;
& ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ&r ......
/**
* @author ºýÍ¿¹í
* ÔÚ½¨Á¢Á¬½Ó֮ǰÐèҪһЩ׼±¸¹¤×÷£º
* ÔÚ¿ØÖÆÃæ°åÉÏͨ¹ý“¹ÜÀí¹¤¾ß”µÄ“Êý¾ÝÔ´(ODBC)”´ò¿ª“ODBCÊý¾ÝÔ´¹ÜÀíÆ÷”¶Ô»°¿ò£¬
* µ¥»÷“ϵͳDSN”Ñ¡Ï£¬È»ºóµ¥»÷“Ìí¼Ó”°´Å¥£¬µÃµ½“´´½¨Êý¾ÝÔ´”¶Ô»°¿ò£¬
......
Á¬½Ósql serverÊý¾Ý¿âÓõ½µÄÃüÃû¿Õ¼äÊÇusing System.Data.SqlClient;
Êý¾Ý¿âÁ¬½Ó´úÂë:¿ÉÒÔÔÚ´óÀàÖ®ÏÂÉùÃ÷ public SqlConnection myConnection; //sqlÁ¬½Ó¶ÔÏó
&nbs ......
Õâ¾ÍÒª´ÓË«ÒýºÅºÍµ¥ÒýºÅµÄ×÷Óý²Æð£º
Ë«ÒýºÅÀïÃæµÄ×ֶλᾹý±àÒëÆ÷½âÊÍÈ»ºóÔÙµ±×÷HTML´úÂëÊä³ö£¬µ«Êǵ¥ÒýºÅÀïÃæµÄ²»ÐèÒª½âÊÍ£¬Ö±½ÓÊä³ö¡£ÀýÈ磺
$abc='I love u';
echo $abc //½á¹ûÊÇ:I love u
echo '$abc' //½á¹ûÊ ......