SQL: Difference between revisions
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
=== MySQL === | === MySQL === | ||
* Link: https://www.mysql.com/ | * Link: https://www.mysql.com/ | ||
* | * released by: Oracle | ||
=== MariaDB === | === MariaDB === | ||
* Link: https://mariadb.com/ | * Link: https://mariadb.com/ | ||
* | * released by: MariaDB Corporation Ab | ||
=== SQL Server === | === SQL Server === | ||
* Link: https://www.microsoft.com/sql-server | * Link: https://www.microsoft.com/sql-server | ||
* | * released by: Microsoft | ||
* Comment: supports options 'driver' and 'schema' | * Comment: supports options 'driver' and 'schema' | ||
=== SQLite === | |||
* Link: https://www.microsoft.com/sql-server | |||
* released by: Microsoft | |||
* Comment: no support for options 'user', 'password', 'server', 'driver' and 'schema' | |||
== Modes == | == Modes == |
Revision as of 22:49, 6 December 2019
Structured Query Language (SQL) is a database language that is used in relational database management system such MySQL, SQL Server, PostgreSQL, or SQLite. Further information can be found here: https://en.wikipedia.org/wiki/SQL
Supported engines
MySQL
- Link: https://www.mysql.com/
- released by: Oracle
MariaDB
- Link: https://mariadb.com/
- released by: MariaDB Corporation Ab
SQL Server
- Link: https://www.microsoft.com/sql-server
- released by: Microsoft
- Comment: supports options 'driver' and 'schema'
SQLite
- Link: https://www.microsoft.com/sql-server
- released by: Microsoft
- Comment: no support for options 'user', 'password', 'server', 'driver' and 'schema'
Modes
There are basically two modes supported: You can add data to an existing database into or you can fetch data from an database.
Insert/add data to a database
- Database and Table must already exist.
- Values for all columns of an existing table must be submitted.