What is SQL?

SQL (Structured Query Language) is a computer language used to perform operations on relational databases. SQL not only allows you to manipulate data but also to create, modify and secure their organization in a database.

We will show you some examples of simple queries.

Before starting, here are some conventions used during this article:

 – Product will designate the name of the table recording all the data on the products
 – productPrice will designate the field of the product table that will record the prices
 – productRef will designate the field of the table product which will record the product references

Here are the fundamental SQL queries:

– « SELECT * FROM Product » is used to select all the records of the Product table 

– « SELECT * FROM Product WHERE productRef = 32 » allows you to select the product whose reference is 32

– « UPDATE Product SET productPrix = 40 WHERE productRef = 32 » allows to modify the price of product 32

– « INSERT INTO Product (productRef, productPrice) VALUES (1152, 42) » is used to add product 1152 to the database with 42 as a value for the productPrice field

– « DELETE FROM Product WHERE productRef = 32 » allows you to delete product 32

There are obviously many other SQL queries that allow you to modify, order or organize data.

To find out more, we invite you to take our training course dedicated to SQL.