Vinicius Bortoletto vinibortoletto
vinibortoletto
/ remove_manual_id_trigger.sql
Created
November 22, 2022 13:13
— forked from rafaeltedesco/remove_manual_id_trigger.sql
Guarantee that user cannot insert a manual id on a auto_increment field
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
| DROP TRIGGER IF EXISTS sakila.bf_insert_actor; | |
| DELIMITER $$ | |
| CREATE TRIGGER bf_insert_actor | |
| BEFORE INSERT ON sakila.actor | |
| FOR EACH ROW | |
| BEGIN | |
| IF NEW.actor_id IS NOT NULL THEN | |
| SET NEW.actor_id = null; |
vinibortoletto
/ CheatSheet.sql
Last active
November 22, 2022 00:50
— 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 (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 |