MySQL sql和mysql有什么区别
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/14840808/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the difference between sql and mysql
提问by
I am new to databases and I was wondering: What is the difference between SQLand MySQL?
我是数据库的新手,我想知道:SQL和MySQL之间有什么区别?
回答by Oded
SQL- Structured Query Language. It is declarative computer language aimed at querying relational databases.
SQL- 结构化查询语言。它是一种声明式计算机语言,旨在查询关系数据库。
MySQLis a relational database - a piece of software optimized for data storage and retrieval. There are many such databases - Oracle, Microsoft SQL Server, SQLite and many others are examples of such.
MySQL是一种关系数据库——一种针对数据存储和检索进行了优化的软件。有很多这样的数据库——Oracle、Microsoft SQL Server、SQLite 和许多其他数据库都是这样的例子。
回答by Tom
SQL is Structured Query Language
SQL 是结构化查询语言
MySQL is a relational database management system. You can submit SQL queries to the MySQL database to store, retrieve, modify or delete data.
MySQL 是一个关系型数据库管理系统。您可以向 MySQL 数据库提交 SQL 查询以存储、检索、修改或删除数据。
回答by Gyhth
SQL stands for Structured Query Language, and is the basis for which all Relational Database Management Systems allow the user to add, remove, update, or select records. Things like MySQ are the actual Management Systems which allow you to store and retrieve your data, whereas SQL is the actual language to do so.
SQL 代表结构化查询语言,是所有关系数据库管理系统允许用户添加、删除、更新或选择记录的基础。MySQ 之类的东西是实际的管理系统,它允许您存储和检索数据,而 SQL 是这样做的实际语言。
The basic SQL is somewhat universal - Selects usually look the same, Inserts, Updates, Deletes, etc. Once you get beyond the basics, the commands and abilities of your individual Databases vary, and this is where you get people who are Oracle experts, MySQL, SQL Server, etc.
基本的 SQL 有点通用——选择通常看起来一样,插入、更新、删除等。一旦你超越了基础,你的个人数据库的命令和能力就会有所不同,这就是你得到 Oracle 专家的地方, MySQL、SQL Server 等
Basically, MySQL is one of many books holding everything, and SQL is how you go about reading that book.
基本上,MySQL 是包含所有内容的众多书籍之一,而 SQL 是您阅读该书的方式。
回答by j.jerrod.taylor
SQL is the actual language that as defined by the ISO and ANSI. Hereis a link to the Wikipedia article. MySQL is a specific implementation of this standard. I believe Oracle bought the company that originally developed MySQL. Other companies also have their own implementations of the SQL standard.
SQL 是由 ISO 和 ANSI 定义的实际语言。这是维基百科文章的链接。MySQL 是该标准的具体实现。我相信甲骨文收购了最初开发 MySQL 的公司。其他公司也有自己的 SQL 标准实现。
回答by MegaMilivoje
SQL stands for Structured Query Language, and it is a programming language designed for querying data from a database. MySQL is a relational database management system, which is a completely different thing.
SQL代表Structured Query Language,它是一种设计用于从数据库查询数据的编程语言。MySQL 是一个关系型数据库管理系统,这是一个完全不同的东西。
MySQL is an open-source platform that uses SQL, just like MSSQL, which is Microsoft's product (not open-source) that uses SQL for database management.
MySQL是一个使用SQL的开源平台,就像MSSQL一样,它是微软的产品(非开源),使用SQL进行数据库管理。