Glossary term

SQL (Structured Query Language)

SMore terms under S

SQL, or Structured Query Language, is a language for asking a database for information and changing the records it stores. It is commonly used with information organized into related tables.

Imagine a products table with a name and price for each item, arranged in rows and columns. This instruction, called a query, asks for products costing less than 50 and lists them in price order:

SQL · ask a table for matching records
SELECT name, price
FROM products
WHERE price < 50
ORDER BY price;

The result is a set of matching records. The website can use those records to build a product list or report.

Database products including MySQL and PostgreSQL use SQL, with some differences in the instructions each supports.

Sources

← Browse Glossary: S