½«Ô¶³ÌÊý¾Ý¿âµ¹µ½±¾µØµÄ·½·¨£¨MySql£©
Dos½øÈëMySqlµÄbinĿ¼,Ö´ÐУºmysqldump -hÔ¶³ÌÊý¾Ý¿âIP Êý¾Ý¿âÃû×Ö -uÔ¶³ÌÊý¾Ý¿âÓû§Ãû -pÔ¶³ÌÊý¾Ý¿âÃÜÂë --add-drop-table | mysql ±¾µØÊý¾Ý¿âÃû×Ö -u±¾µØÊý¾Ý¿âÓû§Ãû -p±¾µØÊý¾Ý¿âÃÜÂë
ÔÚ¾ÖÓòÍøÄÚ²âÊԳɹ¦
Ïà¹ØÎĵµ£º
Ôø¾Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈÐ¶ÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......
Ò»¡¢
¿ØÖÆÁ÷³Ìº¯Êý
a)
CASE WHEN THEN
º¯Êý
Óï·¨£º
CASE value WHEN [compare-value]
THEN result [WHEN [compare-value] THEN result ……] [ELSE result ] END CASE WHEN
[condition] THEN result [WHEN[condition] THEN result …… ......
http://www.developer.com/java/data/article.php/3417381/Using-JDBC-with-MySQL-Getting-Started.htm#Preface
Preface
Purpose
The purpose of this lesson is to get you beyond the initial hurdles involved in:
Downloading and installing a MySQL database server.
Preparing that database for use with JDBC ......
ÎÊ£º
±ÈÈçÎÒÏëÖ±½ÓÔÚphp µÄ½Å±¾Àïдһ¸öÀàËÆ£¬install.phpµÄ½Å±¾
Õâ¸ö½Å±¾µÄ×÷ÓþÍÊÇ£¬Á¬½ÓmysqlÊý¾Ý¿â£¬²¢½¨Á¢ÎÒËùÏëÒª½¨Á¢µÄÊý¾Ý¿â£¬Êý¾Ý±í£¬ÒÔ¼°Ïà¹Ø×ֶΡ£
Çë¾ßÌåдһ¸öÀý×Ó£¬Ð»Ð»£¡
______________________________________________________________________________________________
´ð1£º
連½Ó·½· ......