SQL: Difference between revisions
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 16: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
- Link: https://www.mysql.com/
- Creator/maintainer: Oracle
MS SQL Server
- Link: https://www.microsoft.com/sql-server
- Creator/maintainer: Microsoft
- 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
- Database and Table must already exist.
- Values for all columns of an existing table must be submitted.