Help with SQL commands to interact with a MySQL database
- Mac /usr/local/mysql/bin
- Windows /Program Files/MySQL/MySQL version/bin
- Xampp /xampp/mysql/bin
Diogo Vieira diogocav
diogocav
/ CheatSheet.sql
Created
November 22, 2022 17:15
— forked from FP-Coding/CheatSheet.sql
Cheatsheet - SQL
This file contains hidden or 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
| * - significa nome de todas colunas; | |
| ; - Não esquecer do ponto e vírgula | |
| - Query padrão - SELECT | |
| SELECT (coluna_nome) FROM nome_database.nome_tabela; | |
| - Query do valor de uma operação ou valor fixo | |
| SELECT valor AS nome_coluna, valor2 AS nome_coluna_2; | |
| - Query com CONCAT |
diogocav
/ template-docker-compose.yaml
Created
November 18, 2022 04:50
— forked from vinibortoletto/template-docker-compose.yaml
Template para o docker.compose.yaml
This file contains hidden or 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
| version: '3' | |
| services: | |
| frontend: | |
| build: frontend/ | |
| restart: always | |
| ports: | |
| - 3000:3000 | |
| depends_on: | |
| - backend |
diogocav
/ mysql_cheat_sheet.md
Created
November 18, 2022 04:49
— forked from bradtraversy/mysql_cheat_sheet.md
MySQL Cheat Sheet
diogocav
/ comandos-docker.md
Last active
January 17, 2023 14:00
— forked from vinibortoletto/comandos-docker.md
Comandos Docker
Quando você tem contêineres do Docker em execução, é preciso pará-los primeiro antes de exclui-los.
Parar todos os contêineres em execução: docker stop $(docker ps -a -q)
Excluir todos os contêineres parados: docker rm $(docker ps -a -q)
docker -v
diogocav
/ gist:7a81f2dbbe70459c89b60882fbfbf076
Created
September 30, 2022 17:23
— forked from bruno-alves7/gist:640e37002aa978d13c1fe64b3c1c8777
Tópicos JS para revisar