MYSQL 真的那么强大而好学？？高分探讨。

有没有MS-SQL 那种查询分析器或者管理器什么的？
图形化管理工具：SQLYOG不知道MYSQL 如何才能学好呢
先看看MYSQL　HELP，再多动手实践MYSQL 真的那么强大而好学？
NO，主要是MYSQL是FREE的，但被ORACLE收购后，开发速度似乎慢了许多，不知道ORACLE
是怎么考虑的，前途不明朗。

先读三遍《数据库系统概论》 (掌握基础知识和概念) 然后再粗略浏览一遍MYSQL的官方手册。（方便以后查找，避免类似于考试的时候，给你本政治书也不知道答案在第几章，第几页）MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html

官方的 mysql query browser / mysql administrator
可以直接在官网下载。
http://dev.mysql.com/downloads/gui-tools/5.0.html

有，n多，自己选择自己喜欢的吧：
PHPMyAdmin
MySQL-Front
Navicat
Toad For MySQL
SQLyog

如果已前有学过MSSQL的，再学MYSQL那就很容易了，基本语名跟MSSQL是一样的

MYSQL 被SUN收购，之后再被ORACLE收购。其开发进度没有没明显变化！所以没有变慢之说。
C.1.2. Changes in MySQL 5.4.3 (06 October 2009)
C.1.3. Changes in MySQL 5.4.2 (01 September 2009)
C.1.4. Changes in MySQL 5.4.1 (22 June 2009)
C.1.5. Changes in MySQL 5.4.0 (05 April 2009 Beta)
C.1.1. Changes in MySQL 5.1.41 (05 November 2009)
C.1.2. Changes in MySQL 5.1.40 (06 October 2009)
C.1.3. Changes in MySQL 5.1.39 (04 September 2009)
C.1.4. Changes in MySQL 5.1.38 (01 September 2009)
C.1.5. Release Notes for MySQL Enterprise 5.1.37sp1 [QSP] (10 October 2009)
C.1.6. Changes in MySQL 5.1.37 (13 July 2009)
C.1.7. Changes in MySQL 5.1.36 (16 June 2009)
C.1.8. Changes in MySQL 5.1.35 (13 May 2009)
C.1.9. Release Notes for MySQL Enterprise 5.1.34sp1 [QSP] (25 June 2009)
C.1.10. Changes in MySQL 5.1.34 (02 April 2009)
C.1.11. Changes in MySQL 5.1.33 (13 March 2009)
C.1.12. Changes in MySQL 5.1.32 (14 February 2009)
C.1.13. Release Notes for MySQL Enterprise 5.1.31sp1 [QSP] (19 March 2009)
C.1.14. Changes in MySQL 5.1.31 (19 January 2009)
C.1.15. Changes in MySQL 5.1.30 (14 November 2008 General Availability)
C.1.16. Changes in MySQL 5.1.29 (11 October 2008)
C.1.17. Changes in MySQL 5.1.28 (28 August 2008)
C.1.18. Changes in MySQL 5.1.27 (Not released)
C.1.19. Changes in MySQL 5.1.26 (30 June 2008)
C.1.20. Changes in MySQL 5.1.25 (28 May 2008)
C.1.21. Changes in MySQL 5.1.24 (08 April 2008)
C.1.22. Changes in MySQL 5.1.23 (29 January 2008)
C.1.23. Changes in MySQL 5.1.22 (24 September 2007 Release Candidate)
C.1.24. Changes in MySQL 5.1.21 (16 August 2007)
C.1.25. Changes in MySQL 5.1.20 (25 June 2007)
C.1.26. Changes in MySQL 5.1.19 (25 May 2007)
C.1.27. Changes in MySQL 5.1.18 (08 May 2007)
C.1.28. Changes in MySQL 5.1.17 (04 April 2007)
C.1.29. Changes in MySQL 5.1.16 (26 February 2007)
C.1.30. Changes in MySQL 5.1.15 (25 January 2007)
C.1.31. Changes in MySQL 5.1.14 (05 December 2006)
C.1.32. Changes in MySQL 5.1.13 (Not released)
C.1.33. Changes in MySQL 5.1.12 (24 October 2006)
C.1.34. Changes in MySQL 5.1.11 (26 May 2006)
C.1.35. Changes in MySQL 5.1.10 (Not released)
C.1.36. Changes in MySQL 5.1.9 (12 April 2006)
C.1.37. Changes in MySQL 5.1.8 (Not released)
C.1.38. Changes in MySQL 5.1.7 (27 February 2006)
C.1.39. Changes in MySQL 5.1.6 (01 February 2006)
C.1.40. Changes in MySQL 5.1.5 (10 January 2006)
C.1.41. Changes in MySQL 5.1.4 (21 December 2005)
C.1.42. Changes in MySQL 5.1.3 (29 November 2005)
C.1.43. Changes in MySQL 5.1.2 (Not released)
C.1.44. Changes in MySQL 5.1.1 (Not released) C.1.1. Changes in MySQL 5.0.88 (04 November 2009)
C.1.2. Changes in MySQL 5.0.87 (15 October 2009)
C.1.3. Changes in MySQL 5.0.86 (09 September 2009)
C.1.4. Changes in MySQL 5.0.85 (11 August 2009)
C.1.5. Release Notes for MySQL Enterprise 5.0.84sp1 [QSP] (30 September 2009)
C.1.6. Changes in MySQL 5.0.84 (07 July 2009)
C.1.7. Changes in MySQL 5.0.83 (29 May 2009)
C.1.8. Release Notes for MySQL Enterprise 5.0.82sp1 [QSP] (21 July 2009)
C.1.9. Changes in MySQL 5.0.82 (20 May 2009)
C.1.10. Release Notes for MySQL Community Server 5.0.81 (01 May 2009)
C.1.11. Release Notes for MySQL Enterprise 5.0.80 [MRU] (01 May 2009)
C.1.12. Release Notes for MySQL Enterprise 5.0.79 [MRU] (09 March 2009)
C.1.13. Release Notes for MySQL Enterprise 5.0.78 [MRU] (06 February 2009)
C.1.14. Release Notes for MySQL Community Server 5.0.77 (28 January 2009)
C.1.15. Release Notes for MySQL Enterprise 5.0.76 [MRU] (05 January 2009)
C.1.16. Release Notes for MySQL Community Server 5.0.75 (17 December 2008)
C.1.17. Release Notes for MySQL Enterprise 5.0.74sp1 [QSP] (30 April 2009)
C.1.18. Release Notes for MySQL Enterprise 5.0.74 [MRU] (03 December 2008)
C.1.19. Release Notes for MySQL Enterprise 5.0.72sp1 [QSP] (13 January 2009)
C.1.20. Release Notes for MySQL Enterprise 5.0.72 [MRU] (24 October 2008)
C.1.21. Release Notes for MySQL Enterprise 5.0.70 [MRU] (27 September 2008)
C.1.22. Release Notes for MySQL Enterprise 5.0.68 [MRU] (13 August 2008)
C.1.23. Release Notes for MySQL Community Server 5.0.67 (04 August 2008)
C.1.24. Release Notes for MySQL Enterprise 5.0.66sp1 [QSP] (23 October 2008)
C.1.25. Release Notes for MySQL Enterprise 5.0.66a [MRU] (16 July 2008)
C.1.26. Release Notes for MySQL Enterprise 5.0.66 [MRU] (09 July 2008)
C.1.27. Release Notes for MySQL Enterprise 5.0.64 [MRU] (10 June 2008)
C.1.28. Release Notes for MySQL Enterprise 5.0.62 [MRU] (12 May 2008)
C.1.29. Release Notes for MySQL Enterprise 5.0.60sp1 [QSP] (27 June 2008)
C.1.30. Release Notes for MySQL Enterprise 5.0.60 [MRU] (28 April 2008)
C.1.31. Release Notes for MySQL Enterprise 5.0.58 [MRU] (05 March 2008)
C.1.32. Release Notes for MySQL Enterprise 5.0.56sp1 [QSP] (30 March 2008)
C.1.33. Release Notes for MySQL Enterprise 5.0.56 [MRU] (06 February 2008)
C.1.34. Release Notes for MySQL Enterprise 5.0.54a [MRU] (11 January 2008)
C.1.35. Release Notes for MySQL Enterprise 5.0.54 [MRU] (14 December 2007)
C.1.36. Release Notes for MySQL Enterprise 5.0.52 [MRU] (30 November 2007)
C.1.37. Release Notes for MySQL Community Server 5.0.51b (24 April 2008)
C.1.38. Release Notes for MySQL Community Server 5.0.51a (11 January 2008)
C.1.39. Release Notes for MySQL Community Server 5.0.51 (15 November 2007)
C.1.40. Release Notes for MySQL Enterprise 5.0.50sp1a [QSP] (11 January 2008)
C.1.41. Release Notes for MySQL Enterprise 5.0.50sp1 [QSP] (12 December 2007)
C.1.42. Release Notes for MySQL Enterprise 5.0.50 [MRU] (19 October 2007)
C.1.43. Release Notes for MySQL Enterprise 5.0.48 [MRU] (27 August 2007)
C.1.44. Release Notes for MySQL Enterprise 5.0.46 [MRU] (13 July 2007)
C.1.45. Release Notes for MySQL Community Server 5.0.45 (04 July 2007)
C.1.46. Release Notes for MySQL Enterprise 5.0.44sp1 [QSP] (01 August 2007)
C.1.47. Release Notes for MySQL Enterprise 5.0.44 [MRU] (21 June 2007)
C.1.48. Release Notes for MySQL Enterprise 5.0.42 [MRU] (23 May 2007)
C.1.49. Release Notes for MySQL Community Server 5.0.41 (01 May 2007)
C.1.50. Release Notes for MySQL Enterprise 5.0.40 [MRU] (17 April 2007)
C.1.51. Release Notes for MySQL Enterprise 5.0.38 [MRU] (20 March 2007)
C.1.52. Release Notes for MySQL Community Server 5.0.37 (27 February 2007)
C.1.53. Release Notes for MySQL Enterprise 5.0.36sp1 [QSP] (12 April 2007)
C.1.54. Release Notes for MySQL Enterprise 5.0.36 [MRU] (20 February 2007)
C.1.55. Release Notes for MySQL Enterprise 5.0.34 [MRU] (17 January 2007)
C.1.56. Release Notes for MySQL Community Server 5.0.33 (09 January 2007)
C.1.57. Release Notes for MySQL Enterprise 5.0.32 [MRU] (20 December 2006)
C.1.58. Release Notes for MySQL Enterprise 5.0.30sp1 [QSP] (19 January 2007)
C.1.59. Release Notes for MySQL Enterprise 5.0.30 [MRU] (14 November 2006)
C.1.60. Release Notes for MySQL Enterprise 5.0.28 (24 October 2006)
C.1.61. Release Notes for MySQL Community Server 5.0.27 (21 October 2006)
C.1.62. Changes in MySQL 5.0.26 (03 October 2006)
C.1.63. Changes in MySQL 5.0.25 (15 September 2006)
C.1.64. Changes in MySQL 5.0.24a (25 August 2006)
C.1.65. Changes in MySQL 5.0.24 (27 July 2006)
C.1.66. Changes in MySQL 5.0.23 (Not released)
C.1.67. Changes in MySQL 5.0.22 (24 May 2006)
C.1.68. Changes in MySQL 5.0.21 (02 May 2006)
C.1.69. Changes in MySQL 5.0.20a (18 April 2006)
C.1.70. Changes in MySQL 5.0.20 (31 March 2006)
C.1.71. Changes in MySQL 5.0.19 (04 March 2006)
C.1.72. Changes in MySQL 5.0.18 (21 December 2005)
C.1.73. Changes in MySQL 5.0.17 (14 December 2005)
C.1.74. Changes in MySQL 5.0.16 (10 November 2005)
C.1.75. Changes in MySQL 5.0.15 (19 October 2005 Production)
C.1.76. Changes in MySQL 5.0.14 (Not released)
C.1.77. Changes in MySQL 5.0.13 (22 September 2005 Release Candidate)
C.1.78. Changes in MySQL 5.0.12 (02 September 2005)
C.1.79. Changes in MySQL 5.0.11 (06 August 2005)
C.1.80. Changes in MySQL 5.0.10 (27 July 2005)
C.1.81. Changes in MySQL 5.0.9 (15 July 2005)
C.1.82. Changes in MySQL 5.0.8 (Not released)
C.1.83. Changes in MySQL 5.0.7 (10 June 2005)
C.1.84. Changes in MySQL 5.0.6 (26 May 2005)
C.1.85. Changes in MySQL 5.0.5 (Not released)
C.1.86. Changes in MySQL 5.0.4 (16 April 2005)
C.1.87. Changes in MySQL 5.0.3 (23 March 2005 Beta)
C.1.88. Changes in MySQL 5.0.2 (01 December 2004)
C.1.89. Changes in MySQL 5.0.1 (27 July 2004)
C.1.90. Changes in MySQL 5.0.0 (22 December 2003 Alpha)

目前的开发进度还是可以的因为mysql越来越完善与功能多，所以开发进度肯定会慢点....目前也是三个大版本同时进行
5.0.X-5.1.X
5.4.X
6.0.X不管那个数据库产品使用其到合适的场合就是好东西，错用可能就会不太好甚至可能笑话打比喻：总不能用飞机引擎安装到拖拉机上。
把拖拉机发动机安装到BMW上关键就看你自己的兴趣....如何学好，建议是仔细阅读官方文档，以及测试文档上描述的东西，最好阅读英文版本的还有最好是实践

另外补充一点...mysql 是准确说是开源软件 ...但是不能完全说是免费的mysql是以小巧，以及满足web2.0应用为主的，当然也开始超出此范围...

学习了，工作到现在两年了，一直用mysql，但感觉长进很少

MYSQL功能并不是很强，相对于商业数据库而言（ORACLE、SYBAE　ASE（ASA）、SQLSERVER）
比如，没有递归查询、不支持排名（窗口）函数、不支持TRIGGER的回滚、CHECK没有作用等等，
当然根据你自己的情况判定是否使用MYSQL。从学习的角度讲，先学习商业数据库。

不知道MYSQL 如何才能学好呢？
我是直接看手册，现在有中文版的，以前没有。

有没有MS-SQL 那种查询分析器或者管理器什么的？
除了上面各位所讲的，还有一个EMS SQL manager for MySQL除了wwwwb所说的外，MySQL还不具有自引用的update
另外也没有一个完善的表空间，几个文件就代表一个表。总体来说MySQL没有它的开发商吹的那么好，但少量数据的简单查询它可能是最快的。
SELECT 是它的强项，所以它在web上应用得多。

调试易

MYSQL 真的那么强大而好学？？高分探讨。

解决方案 »