Created
February 11, 2023 03:00
-
-
Save cfigueiroa/afc518ab0b235c2f2c771732a9cd804a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- conectando no banco de dados e comandos básicos | |
-- sudo -i -u postgres | |
-- psql | |
-- \!clear | |
-- \l | |
-- \c padaria_sucesso | |
-- \dt | |
-- | |
SELECT * FROM clientes; | |
SELECT (cpf) FROM clientes; | |
SELECT (cpf, nome) FROM clientes; | |
SELECT * FROM clientes LIMIT 2; | |
SELECT * FROM clientes LIMIT 2 ORDER BY numero_compras DESC; | |
SELECT * FROM clientes LIMIT 2 ORDER BY numero_compras ASC; | |
SELECT * FROM clientes LIMIT 2 ORDER BY nome DESC; | |
SELECT * FROM clientes LIMIT 2 ORDER BY nome ASC; | |
SELECT * FROM receitas JOIN categorias ON receitas.id_categoria = categorias.id; | |
SELECT receitas.*, categorias.nome AS nome_categoria FROM receitas JOIN categorias ON receitas.id_categoria = categorias.id; | |
SELECT receitas.id, receitas.titulo, receitas.ingredientes, receitas.preparo, categorias.nome AS nome_categoria FROM receitas JOIN categorias ON receitas.id_categoria = categorias.id; | |
SELECT receitas.id, receitas.titulo, receitas.ingredientes, receitas.preparo, categorias.nome AS nome_categoria FROM receitas JOIN categorias ON receitas.id_categoria = categorias.id WHERE receitas.id = 4; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment