æ¹æ³/æ¥éª¤
1
1ãå¨å®ç½ä¸ä¸è½½MySQLæ°æ®ï¼ç¹å»Downloadå¼å§ä¸è½½mysqlæ°æ®åºã
请ç¹å»è¾å ¥å¾çæè¿°
ä¸è½½å®æåï¼å¼å§è§£å该å缩å ï¼ç¹å»setup.exeï¼å¼å§è¿è¡å®è£ ã
请ç¹å»è¾å ¥å¾çæè¿°
éæ©é»è®¤è®¾ç½®ï¼ç¹å»Next---Next---Next---Installï¼è¿è¡mysqlå®è£ ï¼æåç¹å»closeï¼åmysqlå®è£ æåã
请ç¹å»è¾å ¥å¾çæè¿°
请ç¹å»è¾å ¥å¾çæè¿°
请ç¹å»è¾å ¥å¾çæè¿°
请ç¹å»è¾å ¥å¾çæè¿°
å°mysqlçå®è£ ç®å½ä¸çbinæ件æå¨è·¯å¾æ¾å ¥ç¯å¢åéPATHä¸ï¼è¿æ ·ä¿è¯å¨cmdç¯å¢ä¸å¯ä»¥è®¿é®mysqlå½ä»¤ã
请ç¹å»è¾å ¥å¾çæè¿°
éæ© æççµè|管ç|æå¡ï¼è®¾ç½®mysqlæå¡ä¸ºèªå¯å¨ï¼å¹¶å¯å¨mysqlæå¡ã
请ç¹å»è¾å ¥å¾çæè¿°
æå¼mysqlæ§å¶å°ï¼è¾å ¥å¯ç ï¼å³å¯ç»å½mysqlæ§å¶å°ã
请ç¹å»è¾å ¥å¾çæè¿°
åºæ¬ç¨æ³ï¼
mysql -h localhost -u {userName} -p {passWord}ï¼è¿è¡ç»å½mysqlæ§å¶å°ã
è¾å ¥statusï¼å¯ä»¥æ¥çå½åMySQLçç¶æä¿¡æ¯ã
请ç¹å»è¾å ¥å¾çæè¿°
åºæ¬è¯å¥ä½¿ç¨ï¼å æ¬å¢å æ¹æ¥è¯å¥ï¼
select * from table1;
delete from table1;
update from table1 where {where};
é«çº§ä½¿ç¨è¯å¥ï¼å æ¬ï¼
å¤è¡¨èæ¥ï¼from A join B on A.id=B.idï¼
æåºï¼order by ;
åç»ï¼group;
å页ï¼limit offset,length çã
ææ¡ä»¥ä¸åºæ¬ç¨æ³ï¼å°±å·²ç»åºæ¬äºè§£MySQLç使ç¨è¿ç¨äºã