SQL: Difference between revisions

From SweepMe! Wiki
Jump to navigation Jump to search
No edit summary
Line 11: Line 11:
* Creator/maintainer: Microsoft
* Creator/maintainer: Microsoft
* Comment: supports options 'driver' and 'schema'
* Comment: supports options '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 ===
=== 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 ===
*





Revision as of 15:57, 1 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

MS SQL Server


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