MySQL sqlite、SQL AND MYSQL的区别及学习技巧
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4851119/
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
Differences between sqlite, SQL AND MYSQL and learning tips
提问by Dorji
I have quite done with my web-programming skills and now i thought of learning database languages.
我已经完成了我的网络编程技能，现在我想学习数据库语言。
But I am confuse with the difference between sqlite, SQLand MySQL.
但我对sqlite,SQL和之间的区别感到困惑MySQL。
So can anyone recommend me the steps of learning database with above languages(zero knowledge).
那么任何人都可以向我推荐使用上述语言（零知识）学习数据库的步骤。
回答by Hiyasat
Start to learn one engine and I recommend (Microsoft) SQL Server, and the conversion will be easy.
开始学习一个引擎，我推荐（微软）SQL Server，转换会很容易。
But it is important to note that SQL Server and MySQL support stored procedures but SQLite does not.
但需要注意的是，SQL Server 和 MySQL 支持存储过程，而 SQLite 不支持。
SQLite is file-based, SQL Server and MySQL are server-based
SQLite 是基于文件的，SQL Server 和 MySQL 是基于服务器的
回答by Andrey
SQL is query language. MySQL is client-server relational database management system (RDBMS). Sqlite is embeddable relational database management system.
SQL 是查询语言。MySQL 是客户端-服务器关系数据库管理系统 (RDBMS)。Sqlite 是嵌入式关系数据库管理系统。
回答by Akshay Paliwal
SQL- Structured Query Language - (To query database)
SQL- 结构化查询语言 - （查询数据库）
MySQL- Client Server Database - (Uses SQL to manage data, Has User Interface (UI))
MySQL- 客户端服务器数据库 - （使用 SQL 管理数据，具有用户界面 (UI)）
SQLite- Small version of MySQL - (for battery operated devices)
SQLite- MySQL 的小版本 - （用于电池供电的设备）
More :
更多的 ：
SQLite:
SQLite：
easier to setup
great for temporary (testing databases)
great for rapid development
great for embedding in an application
doesn't have user management
doesn't have many performance features
doesn't scale well.
更容易设置
非常适合临时（测试数据库）
非常适合快速开发
非常适合嵌入到应用程序中
没有用户管理
没有很多性能特点
不能很好地扩展。
MySQL:
MySQL：
far more difficult/complex to set up
better options for performance tuning
can scale well if tuned properly
can manage users, permissions, etc.
设置起来要困难得多/复杂
性能调优的更好选择
如果调整得当，可以很好地扩展
可以管理用户、权限等。
回答by Aldee
I best recommend to use MySQL first for you to become more familiar on its basic functionality which I suppose you must learn first.
我最好建议您先使用 MySQL，以便您更熟悉它的基本功能，我想您必须先学习这些功能。
回答by bmm
sqlite is the relational database management system most popularly used in mobile device as a database for local storage. Its used in embedded system.
sqlite 是在移动设备中最常用的关系数据库管理系统，作为本地存储的数据库。它用于嵌入式系统。
SQL is also known as Structured Query language is the based on relational algebra. sqlite, MySQL, MSSQL and etcs are part of SQL. They use all sql syntax but each database (sqlite, MySQL, MSSQL) have their own query convention
SQL 也称为结构化查询语言，是基于关系代数的。sqlite、MySQL、MSSQL 等都是 SQL 的一部分。他们使用所有 sql 语法，但每个数据库（sqlite、MySQL、MSSQL）都有自己的查询约定
MySQl is a large scale entriprise database also known as Relational database management system. These database are very scalable and can handle huge terabyes of data.
MySQl 是一个大型企业数据库，也称为关系数据库管理系统。这些数据库具有很强的可扩展性，可以处理海量的数据。
Other database are PostgreSQL and there are many other...
其他数据库是 PostgreSQL，还有许多其他...
回答by CYUBAHIRO Patrick
SQL stands for Structured Query Language; it is a language designed to access and manage data stored in a Relational Database Management System (RDBMS). You can add, retrieve, remove, or access data within a database with the help of SQL at any time using some basic queries. In short, SQL not only allows users to access data stored in a Relational Database Management System but also creates, deletes databases and sets permissions on database tables, views and procedures.
SQL 代表结构化查询语言；它是一种设计用于访问和管理存储在关系数据库管理系统 (RDBMS) 中的数据的语言。您可以随时使用一些基本查询在 SQL 的帮助下添加、检索、删除或访问数据库中的数据。简而言之，SQL 不仅允许用户访问存储在关系数据库管理系统中的数据，还允许创建、删除数据库以及设置对数据库表、视图和过程的权限。
SQLite is a software library that provides a Relational Database Management System. The lite in SQLite means light weight in terms of setup, database administration, and required resource. SQLite has the following noticeable features: self-contained, serverless, zero-configuration and transactional. SQLite is the lite form of SQL which runs on low powered devices or the devices with low memory such as mobile devices, Personal Digital Assistant (PDA) or pocket music players. SQLite is not a client–server database engine. Rather, it is embedded into the end program. SQLite is file-based whereas SQL is a server based.
SQLite 是一个提供关系数据库管理系统的软件库。SQLite 中的 lite 意味着在设置、数据库管理和所需资源方面的轻量级。SQLite 具有以下显着特征：自包含、无服务器、零配置和事务性。SQLite 是 SQL 的精简版，可在低功耗设备或低内存设备上运行，例如移动设备、个人数字助理 (PDA) 或袖珍音乐播放器。SQLite 不是客户端-服务器数据库引擎。相反，它被嵌入到最终程序中。SQLite 是基于文件的，而 SQL 是基于服务器的。
MySQL is an open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). It is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for MySQL is for the purpose of a web database.
MySQL 是使用结构化查询语言 (SQL) 的开源关系数据库管理系统 (RDBMS)。它用于广泛的用途，包括数据仓库、电子商务和日志记录应用程序。MySQL 最常见的用途是用于 Web 数据库。
