对于初学者，MySQL和PostgreSQL之间有很大的区别 [英] For a beginner, is there much difference between MySQL and PostgreSQL

问题描述

对于像我这样的初学者，使用基本的select语句等，或者使用更高级的查询，主要的区别是MySQL和PostgreSQL之间有什么区别吗？

IS there much difference between MySQL and PostgreSQL for a beginner like me, using basic select statements and the like, or are the main differences with using more advanced queries?

推荐答案

之所以我通常在MySQL之前建议PostgreSQL是因为MySQL远离标准（SQL-wise）。它不支持使用窗口函数（8.4版本），公用表表达式（8.4）， CHECK约束，EXCEPT / MINUS运算符，甚至FULL OUTER JOINS ...即使你可能从来没有听说过这些话，你必须在某个时候使用这些概念。

The reason why I usually suggest PostgreSQL before MySQL is because MySQL is far from the standards (SQL-wise). It does not support the use of window functions (8.4 version), common table expressions (8.4), CHECK constraints, EXCEPT/MINUS operator, even FULL OUTER JOINs... Even though you may have never heard of these words, you'll have to use those concepts at some point.

我强烈建议您从PostgreSQL开始，然后您可以了解真正的SQL是什么。然后，您可以决定MySQL是否足够。

I strongly suggest you to start with PostgreSQL, then you can learn what "real" SQL is. Then, you can decide if MySQL is sufficient or not.

我从MySQL开始，我很遗憾。我现在使用PostgreSQL，我喜欢它。

P.S. I started with MySQL and I regretted it. I now use PostgreSQL and I love it.

这篇关于对于初学者，MySQL和PostgreSQL之间有很大的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！