Difference between revisions of "SQL"

From SweepMe! Wiki
Jump to: navigation, search
(MS SQL Server)
(Supported engines)
Line 5: Line 5:
 
=== MySQL ===
 
=== MySQL ===
 
* Link: https://www.mysql.com/
 
* Link: https://www.mysql.com/
* Creator/maintainer: Oracle
+
* released by: Oracle
  
 
=== MariaDB ===
 
=== MariaDB ===
 
* Link: https://mariadb.com/
 
* Link: https://mariadb.com/
* Creator/maintainer: MariaDB Corporation Ab
+
* released by: MariaDB Corporation Ab
  
 
=== SQL Server ===
 
=== SQL Server ===
 
* Link: https://www.microsoft.com/sql-server
 
* Link: https://www.microsoft.com/sql-server
* Creator/maintainer: Microsoft
+
* 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

MariaDB

SQL Server

SQLite

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.

Select and fetch data from a database