MySQLÊý¾Ý¿â´æ·ÅÔÚÄÄ°¡£¿ - MS-SQL Server / »ù´¡Àà
ÔõôÕÒµ½Êý¾Ý¿âµÄλÖ𡣿Çë¸÷λǰ±²Ö¸½Ìһϣ¿Ð¡µÄ·Ç³£¸Ðл£¡
ÏÈÕÒµ½my.cnfÎļþ£¬´ò¿ªºó¿´[data]ϵÄdatadir 2¡¢½øÈëmysqlÖնˣº mysql>show variables like '%datadir%'; ÔÙ²»ÐÐÈ«ÅÌËÑË÷£º¡¡frmÎļþ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data Ðֵܰ´Õâ¸ö·¾¶ÕÒ Ð»Ð»¸÷λǰ±²£¡ ÎÒҲûÕÒµ½£¬¶øÇÒ°²×°ºó¶¼²»ÖªµÀÔõôÓÃËý£¬Ð¶Ôغó×¢²á±íÀïÁôÏÂÁËmysql²»¿ÉÄ¥ÃðµÄºÛ¼££¬ÔÚÿ´ÎÆô¶¯Ê±¶¼ÌáÐÑÎÒmysqlÔø¾´Ò´ÒÀ´¹ý¡£ mysql-4.1.22°æµÄ°²×°ºóÔÚ°²×°Ä¿Â¼ÏÂdataÎļþ¼ÐÏÂÄÜÕÒµ½ÒýÓà mysql-4.1.22°æµÄ°²×°ºóÔÚ°²×°Ä¿Â¼ÏÂdataÎļþ¼ÐÏÂÄÜÕÒµ½ yes ~!~ show variables like '%datadir%';ÒýÓà 2¡¢½øÈëmysqlÖնˣº mysql>show variables like '%datadir%'; ¿ÉÐÐ
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
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)ÖеÄÊý¾ ......