Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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%';




¿ÉÐÐ


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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 ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

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)ÖеÄÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ