Difference between revisions of "SQL"

From SweepMe! Wiki
Jump to: navigation, search
(SQL Server)
Line 1: Line 1:
 
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
 
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 ==
+
= Supported engines =
  
=== MySQL ===
+
== MySQL ==
 
* Link: https://www.mysql.com/
 
* Link: https://www.mysql.com/
 
* released by: Oracle
 
* released by: Oracle
  
=== MariaDB ===
+
== MariaDB ==
 
* Link: https://mariadb.com/
 
* Link: https://mariadb.com/
 
* released by: 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
 
* released by: Microsoft
 
* released by: Microsoft
  
==== Usage ====
+
=== Usage ===
 
 
 
* Options 'driver' and 'schema' are supported
 
* Options 'driver' and 'schema' are supported
  
=== SQLite ===
+
== SQLite ==
 
* Link: https://www.sqlite.org/index.html
 
* Link: https://www.sqlite.org/index.html
 
* released by: Hipp, Wyrick & Company, Inc., (Hwaci)
 
* released by: Hipp, Wyrick & Company, Inc., (Hwaci)
 
* Comment:  no support for options 'user', 'password', 'server', 'driver' and 'schema'
 
* Comment:  no support for options 'user', 'password', 'server', 'driver' and 'schema'
  
==== Usage ====
+
=== Usage ===
 
SQLite databases can be created with tools such as https://sqlitebrowser.org/. To access your database, enter the path in the database field, e.g "C:\test.db".
 
SQLite databases can be created with tools such as https://sqlitebrowser.org/. To access your database, enter the path in the database field, e.g "C:\test.db".
  

Revision as of 23:50, 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

Usage

  • Options 'driver' and 'schema' are supported

SQLite

  • Link: https://www.sqlite.org/index.html
  • released by: Hipp, Wyrick & Company, Inc., (Hwaci)
  • Comment: no support for options 'user', 'password', 'server', 'driver' and 'schema'

Usage

SQLite databases can be created with tools such as https://sqlitebrowser.org/. To access your database, enter the path in the database field, e.g "C:\test.db".

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