Difference between revisions of "SQL"

From SweepMe! Wiki
Jump to: navigation, search
(Supported engines)
(Insert/add data to a database)
Line 24: Line 24:
 
* Database and Table must already exist.
 
* Database and Table must already exist.
 
* Values for all columns of an existing table must be submitted.
 
* 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 19:56, 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

MariaDB

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