Difference between revisions of "SQL"

From SweepMe! Wiki
Jump to: navigation, search
(Modes)
 
(17 intermediate revisions by the same user not shown)
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 ==
+
= Engines =
  
* MySQL
+
Engines or database systems are provided by different companies and projects. The supported ones are listed below. Contact us if you need access to a database that is not yet implemented.
* MS SQL Server
 
  
=== Insert/add data to a database ===
+
== 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
 +
 +
=== Usage ===
 +
* Options 'driver' and 'schema' are supported
 +
 +
== SQLite ==
 +
* Link: https://www.sqlite.org/index.html
 +
* released by: Hipp, Wyrick & Company, Inc., (Hwaci)
 +
 +
=== 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".
 +
* Do not alter properties of your database file. Otherwise your measurement might be aborted.
 +
* Options 'user', 'password', 'server', 'driver', and 'schema' are not supported.
 +
 +
= Modes =
 +
 +
There are basically two modes supported: You can add data into an existing database or you can fetch data from a 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 ==
 +
 +
*
  
=== Select and fetch data from a database ===
 
  
  
 
[[Category:Modules]]
 
[[Category:Modules]]
 
[[Category:Add-On Modules]]
 
[[Category:Add-On Modules]]

Latest revision as of 11:32, 3 December 2020

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

Engines

Engines or database systems are provided by different companies and projects. The supported ones are listed below. Contact us if you need access to a database that is not yet implemented.

MySQL

MariaDB

SQL Server

Usage

  • Options 'driver' and 'schema' are supported

SQLite

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".
  • Do not alter properties of your database file. Otherwise your measurement might be aborted.
  • Options 'user', 'password', 'server', 'driver', and 'schema' are not supported.

Modes

There are basically two modes supported: You can add data into an existing database or you can fetch data from a 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