databaseSQL

Structured Query Language, aka SQL (Sequel) is a database coding language that allows us to manipulate databases.

From extracting information, deleting records to updating databases, SQL can do it all.

Example of SQL Query:

mysql> SELECT id, username, role from users;
+----+----------+------+
| id | username | role |
+----+----------+------+
|  1 | Admin    |    1 |
|  2 | Support  |    3 |
|  3 | Anne     |    5 |
|  5 | Joe      |    5 |
+----+----------+------+
4 rows in set (0.00 sec)

This simple SELECT query, has asked our database to return = id, username and role from table users

Last updated