MySQL ×Ö·û´®º¯Êý£º×Ö·û´®½ØÈ¡
½ØÈ¡province×Ö·û´®ÖеÚÒ»¸ö<br>ǰµÄ×Ö·û´®¡«£¡
update lcjd
set `province` = substring_index( `province` , '<br>', '1' );
ÔÚÐèÒªÌí¼Ó‘0’µÄλÖÃÌí¼ÓÒ»¸ö‘0’
update lcjd
set lc_name2 = concat('0', lc_name2)
WHERE length(lc_name2) = 3
http://www.sqlstudy.com/sql_article.php?id=2008091902
Ïà¹ØÎĵµ£º
ÖÐÎÄÏÔʾÎÊÌâÒ»Ö±ÊÇÀ§ÈÅÎÒÃǵÄÒ»¸öÄÑÌ⣬²»ÐÅÄãÉÏgoogleËÑË÷һϣ¬ÕâÀàµÄÎÊÌâºÍ½â´ð¿ÉÒÔ˵ÊÇÆÌÌì¸ÇµØ£¬ºÃ¶àÍøÕ¾ÉõÖÁ½«ÆäÌá³öÀ´×÷ΪרÌâÀ´ÌÖÂÛ£¬¹ÜÖпú±ª£¬¿É¼ûÒ»°ß¡£
¿ªÊ¼Ò²ÔøÎªÕâ¸öÎÊÌâÍ·ÌÛ£¬ÉÏÍø²éÔÄ´óÁ¿µÄ×ÊÁϺͽâ¾ö·½·¨£¬ÖÕÓÚÕÒµ½ÁËÒ»Öּȼòµ¥ÓÖºÃÓõİ취£¬ÒÔJSP+MYSQL´æ´¢ÎªÀý£¬¼òµ¥½éÉÜÒ ......
µÚÎåÕ ´úÂëÖØÓÃÓ뺯Êý±àд
require()»òinclude()¿ÉÒÔ½«Ò»¸öÎļþÔØÈëµ½php½Å±¾ÖС£
ÕâÁ½¸öº¯Êý¼¸ºõµÈ¼Û£¬Î¨Ò»µÄÇø±ðÊǵ÷ÓÃʧ°Üºórequire()¸ø³öÒ»¸öÖÂÃü´íÎ󣬶øinclude()Ö»¸ø³öÒ»¸ö¾¯¸æ¡£
Èç¹ûWebÒ³Ãæ¾ßÓÐÒ»ÖµÄÍâ¹Û£¬¿ÉÒÔ½«ÏàͬµÄ²¿·Ö·ÖÀëµ½µ¥¶ÀµÄÒ³ÃæÖУ¬È»ºó¿ÉÒÔÔÚphpÖÐʹÓÃrequire()Óï¾ä½«Ä£°åÔªËØ¼ÓÈëµ½Ò³ÃæÖС£
......
1¡¢phpÓëmysql½¨Á¢Á¬½Ó
php.ini ¼ÓÔØmysql×é¼þ
extension=php_mysql.dllǰµÄ;È¥µô
exetension_dir=""·¾¶ÊÇ·ñÕýÈ·
PhpÁ¬½Ómysqlº¯Êý
mysql_connect:¿ªÆôMYSQLÁ¬½Ó
mysql_select_dir:´ò¿ªÒ»¸öÊý¾Ý¿â
@ºÍor die Òþ²Ø´íÎóºÍÌõ¼þÏÔʾ
mysql_connect("Ö÷»ú","Óû§Ãû","ÃÜÂë");
mysql_sele ......
¹Ù·½ÊÖ²áÉÏÊÇÕâôдµÄ£º
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{f ......