rb-projects-access:sqlexamples
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| rb-projects-access:sqlexamples [25/04/2025 10:55] – andrew | rb-projects-access:sqlexamples [25/04/2025 12:13] (current) – andrew | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== SQL examples ====== | ====== SQL examples ====== | ||
| + | |||
| + | Just useful code snippets, examples not functional code. | ||
| + | |||
| ===== Table columns ===== | ===== Table columns ===== | ||
| Line 15: | Line 18: | ||
| - | MariaDB [accesscontrol]> select * from users; | + | > select * from users; |
| +--------+-----------+-----------+----------+-----+---------------------+---------------------+ | +--------+-----------+-----------+----------+-----+---------------------+---------------------+ | ||
| | userID | username | | userID | username | ||
| Line 24: | Line 27: | ||
| +--------+-----------+-----------+----------+-----+---------------------+---------------------+ | +--------+-----------+-----------+----------+-----+---------------------+---------------------+ | ||
| - | + | > SELECT * FROM access; | |
| - | MariaDB [accesscontrol]> SELECT * FROM access; | + | |
| +----------+--------+-------------+--------+ | +----------+--------+-------------+--------+ | ||
| | accessID | doorID | accesslevel | cardID | | | accessID | doorID | accesslevel | cardID | | ||
| Line 44: | Line 46: | ||
| <code sql> | <code sql> | ||
| - | MariaDB [accesscontrol]> select username from users inner join keycards on keycards.issuedTo = users.userID where users.username = ' | + | > select username from users inner join keycards on keycards.issuedTo = users.userID where users.username = ' |
| +----------+ | +----------+ | ||
| | username | | | username | | ||
| Line 51: | Line 53: | ||
| | hs | | | hs | | ||
| +----------+ | +----------+ | ||
| - | 2 rows in set (0.000 sec) | ||
| - | MariaDB [accesscontrol]> select username, keycards.cardNumber from users inner join keycards on keycards.issuedTo = users.userID where users.username = ' | + | > select username, keycards.cardNumber from users inner join keycards on keycards.issuedTo = users.userID where users.username = ' |
| +----------+------------+ | +----------+------------+ | ||
| | username | cardNumber | | | username | cardNumber | | ||
| Line 61: | Line 62: | ||
| 1 row in set (0.000 sec) | 1 row in set (0.000 sec) | ||
| - | MariaDB [accesscontrol]> select username, keycards.cardNumber from users inner join keycards on keycards.issuedTo = users.userID where users.username = ' | + | > select username, keycards.cardNumber from users inner join keycards on keycards.issuedTo = users.userID where users.username = ' |
| +----------+------------+ | +----------+------------+ | ||
| | username | cardNumber | | | username | cardNumber | | ||
| Line 72: | Line 73: | ||
| - | MariaDB [accesscontrol]> SELECT * FROM access JOIN keycards ON access.userID = keycards.userID \G; | + | > SELECT * FROM access JOIN keycards ON access.userID = keycards.userID \G; |
| *************************** 1. row *************************** | *************************** 1. row *************************** | ||
| | | ||
| Line 136: | Line 137: | ||
| - | < | ||
| - | > select cardNumber from keycards inner join users on keycards.issuedTo = users.userID; | ||
| - | +------------+ | ||
| - | | cardNumber | | ||
| - | +------------+ | ||
| - | | 1234 | | ||
| - | | 2345 | | ||
| - | | 3456 | | ||
| - | | 4567 | | ||
| - | +------------+ | ||
| - | 4 rows in set (0.000 sec) | ||
| - | |||
| - | |||
| - | select username from users inner join keycards on keycards.issuedTo = users.userID; | ||
| - | +-----------+ | ||
| - | | username | ||
| - | +-----------+ | ||
| - | | hs | | ||
| - | | hs | | ||
| - | | as | | ||
| - | | os | | ||
| - | +-----------+ | ||
| - | 4 rows in set (0.000 sec) | ||
| - | |||
| - | </ | ||
rb-projects-access/sqlexamples.1745578512.txt.gz · Last modified: by andrew