MysqlÎÊÌâ - MS-SQL Server / ·Ç¼¼Êõ°æ
ÎÒÒѾ°²×°mysqlÁË£¬ÉèÖõĿª»ú²»Æô¶¯£¬µ«ÔÚÎҵĵçÄÔ'->'¹ÜÀí'->'·þÎñºÍÓ¦ÓóÌÐò'->·þÎñÖÐÕÒ²»µ½mysql£¬ÕâÑù¾Íû·¨Æô¶¯ÁË£¬ÎÒÏëѯÎÊÒ»ÏÂÕâµ½µ×ÊÇÔõô»ØÊ£¬ÏÈллÁË
ÓÐºÃ¶àµØ·½ÄØ
×¢²á±í
Æô¶¯Îļþ¼ÐµÈ
nÄã˵µÄÊÇ·þÎñ°É
ÓÐÕâ¸ö·þÎñô¡£¡£¡£ÃüÁîÐÐÆô¶¯
²»Ã÷°×ÕâÊÇÔõô»ØÊ£¡·þÎñÀïÔõôûÓУ¬¸Õ×°ÍêʱÓУ¬ºóÀ´¾ÍûÓÐÁË¡£¾ßÌåµã Ôõô´ò¿ª×¢²á±í£¿ÔõôÆô¶¯Îļþ¼Ð£¿
ÔÚ·þÎñÖиù±¾ÕÒ²»µ½mysql£¬ÔõôÆô¶¯£¿
°²×°ÁËmysql£¬µ«ÔÚÆô¶¯·þÎñÀïÕÒ²»µ½£¬ÕâÊÇÔõô»ØÊ£¬ÓÐûÓÐÖªµÀµÄ°¡£¿£¿£¿
¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
¿ÉÒÔ×Ô¼º°²×°·þÎñ
SQL code:
5.0°æ±¾: mysqld-nt --install --default-files='mysqlµÄiniÅäÖÃÎļþµÄÎļþ' ·þÎñÃû
5.1°æ±¾: mysqld --install --default-files='mysqlµÄiniÅäÖÃÎļþµÄÎļþ' ·þÎñÃû
¿ÉÒÔÓÃÃüÁîÐÐÆô¶¯°¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......