1. MySQLæ¯æenumåsetç±»åï¼SQL Serverä¸æ¯æï¼
2. MySQLä¸æ¯æncharãnvarcharãntextç±»åï¼
3. MySQLæ°æ®åºçéå¢è¯å¥æ¯AUTO_INCREMENTï¼èMS SQLæ¯identity(1,1)ï¼
4. MS SQLé»è®¤å°å¤è¡¨å建è¯å¥çé»è®¤å¼è¡¨ç¤ºæ¯((0))ï¼èå¨MySQLéé¢æ¯ä¸å
许带两æ¬å·çï¼
5. MySQLéè¦ä¸ºè¡¨æå®åå¨ç±»åï¼
6. MS SQLè¯å«ç¬¦æ¯[],[type]表示ä»åºå«äºå
³é®åï¼ä½æ¯MySQLå´æ¯ `ï¼ä¹å°±æ¯æé®1左边çé£ä¸ªç¬¦å·ï¼
7. MS SQLæ¯ægetdate()æ¹æ³è·åå½åæ¶é´æ¥æï¼ä½æ¯MySQLéé¢å¯ä»¥åæ¥æç±»ååæ¶é´ç±»åï¼è·åå½åæ¥ææ¯cur_date()ï¼å½åå®æ´æ¶é´æ¯ now()å½æ°ï¼
8. MS SQLä¸æ¯æreplace intoè¯å¥ï¼ä½æ¯å¨ææ°çSQL Server 2008éé¢ï¼ä¹æ¯æmergeè¯æ³ï¼
9. MySQLæ°æ®åºæ¯æinsert into table1 set t1 = ââ, t2 = ââ ï¼ä½æ¯MS SQLä¸æ¯æè¿æ ·åï¼
10. MySQLæ¯æinsert into tabl1 values (1,1), (1,1), (1,1), (1,1), (1,1), (1,1), (1,1)
11. MS SQLä¸æ¯ælimitè¯å¥ï¼æ¯é常éæ¾çï¼åªè½ç¨top å代limt 0,Nï¼row_number() over()å½æ°å代limit N,Mï¼
12. MySQLå¨å建表æ¶è¦ä¸ºæ¯ä¸ªè¡¨æå®ä¸ä¸ªåå¨å¼æç±»åï¼èMS SQLåªæ¯æä¸ç§åå¨å¼æï¼
13. MySQLä¸æ¯æé»è®¤å¼ä¸ºå½åæ¶é´çdatetimeç±»å(MS SQLå¾å®¹æåå°)ï¼å¨MySQLéé¢æ¯ç¨timestampç±»åï¼
14. MS SQLéé¢æ£æ¥æ¯å¦æè¿ä¸ªè¡¨åå é¤ï¼éè¦è¿æ ·ï¼
if exists (select * from dbo.sysobjects where id = object_id(N'uc_newpm') and OBJECTPROPERTY(id,N'IsUserTable')=1)
ä½æ¯å¨MySQLéé¢åªéè¦ DROP TABLE IF EXISTS cdb_forums;
15. MySQLæ¯ææ 符å·åçæ´æ°ï¼é£ä¹æ¯ä¸æ¯ææ 符å·åçMS SQLå°±è½å¤åºä¸åçæ大æ°åå¨ï¼
16. MySQLä¸æ¯æå¨MS SQLéé¢ä½¿ç¨é常æ¹ä¾¿çvarchar(max)ç±»åï¼è¿ä¸ªç±»åå¨MS SQLéé¢æ¢å¯åä¸è¬æ°æ®åå¨ï¼ä¹å¯ä»¥åblobæ°æ®åå¨ï¼
17. MySQLæ°æ®åºå建éèéç´¢å¼åªéè¦å¨å建表çæ¶åæå®ä¸ºkeyå°±è¡ï¼æ¯å¦ï¼KEY displayorder (fid,displayorder)
å¨MS SQLéé¢å¿
é¡»è¦ï¼
create unique nonclustered index index_uc_protectedmembers_username_appid on dbo.uc_protectedmembers(username asc,appid asc)
18. MySQL textå段类åä¸å
许æé»è®¤å¼ï¼
19. MySQLçä¸ä¸ªè¡¨çæ»å
±å段é¿åº¦ä¸è¶
è¿65XXXã
20. ä¸ä¸ªå¾è¡¨é¢çåºå«å°±æ¯MySQLçå®è£
ç¹å«ç®åï¼èä¸æ件大å°æ110M(éå®è£
ç)ï¼ç¸æ¯å¾®è½¯è¿ä¸ªåºç¶å¤§ç©ï¼å®è£
è¿åº¦æ¥è¯´ç®ç´å°±æ¯.....
21. MySQLç管çå·¥å
·æå 个æ¯è¾å¥½çï¼MySQL_frontåå®æ¹é£ä¸ªå¥ä»¶ï¼ä¸è¿é½æ²¡æSSMSç使ç¨æ¹ä¾¿ï¼è¿æ¯MySQLå¾å¤§çä¸ä¸ªç¼ºç¹ã
22. MySQLçåå¨è¿ç¨åªæ¯åºç°å¨ææ°ççæ¬ä¸ï¼ç¨³å®æ§åæ§è½å¯è½ä¸å¦MS SQLã
23. åæ ·çè´è½½ååï¼MySQLè¦æ¶èæ´å°çCPUåå
åï¼MS SQLçç¡®æ¯å¾èèµæºï¼
24. phpè¿æ¥MySQLæ°æ®åºåMS SQLçæ¹å¼é½å·®ä¸å¤ï¼åªéè¦å°å½æ°çMySQLæ¿æ¢æMS SQLå³å¯ã
25. MySQLæ¯æ date,time,yearç±»åï¼MS SQLå°2008ææ¯ædateåtimeã
温馨提示:内容为网友见解,仅供参考