Skip to content

Instantly share code, notes, and snippets.

View SilasRodrigues19's full-sized avatar
🐒
Attempting to define the undefined in both code and reality

Silas Rodrigues SilasRodrigues19

🐒
Attempting to define the undefined in both code and reality
68 followers · 16 following
View GitHub Profile
@SilasRodrigues19
SilasRodrigues19 / REFERENCES.md
Last active February 17, 2023 15:29
HTML meta tags cheatsheet
@SilasRodrigues19
SilasRodrigues19 / index.html
Created January 25, 2023 16:57
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<h1>index</h1>
@SilasRodrigues19
SilasRodrigues19 / kill.sql
Created January 24, 2023 11:35
KILL DATABASE PROCESS
SELECT CONTACT('KILL', id, ';') FROM INFORMATION_SCHEMA.PROCESSLIST -- WHERE INFO LIKE '%KEY%';
@SilasRodrigues19
SilasRodrigues19 / x.md
Created December 29, 2022 18:20
  • xxxxx
  • yyyyy
@SilasRodrigues19
SilasRodrigues19 / STALuziaEcommerce.sql
Last active December 27, 2022 16:08
Queries com a relação de Notas Fiscais passadas pela Kely, o Mateus informou 132 mas na relação da Kely tem 134
SELECT id AS idpedido,
idcliente AS IDSTALuziaEcommerce,
numerocontrole AS NF,
chaveacesso,
status,
dataentrega
FROM pedidos
WHERE idcliente = '6f865a5c0c01b6f299b436dcb590fa45' -- STA Luzia Ecommerce
AND numerocontrole = '355392';
@SilasRodrigues19
SilasRodrigues19 / nadadores.c
Created December 4, 2022 17:20
#include <stdio.h>
#include <stdlib.h>
#include <conio.h>
#include <string.h>
#include <locale.h>
/*
olimpíada de natação eu quero cadastar os nomes ,com braçadas,metro e pontos dos participantes de cada país.
*/
@SilasRodrigues19
SilasRodrigues19 / webresources.backup.sql
Created November 8, 2022 19:55
Backup for https://github.com/SilasRodrigues19/WebResources
-- --------------------------------------------------------
-- Servidor: 127.0.0.1
-- Versão do servidor: 10.4.25-MariaDB - mariadb.org binary distribution
-- OS do Servidor: Win64
-- HeidiSQL Versão: 12.1.0.6537
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
@SilasRodrigues19
SilasRodrigues19 / findurjob.database.sql
Last active April 18, 2023 19:29
FindUrJob Database Backup
CREATE TABLE jobs (
job_id INT(11) NOT NULL AUTO_INCREMENT,
job_title VARCHAR(255) NOT NULL,
job_requirements VARCHAR(255) NOT NULL,
job_link VARCHAR(255) NOT NULL,
job_level ENUM('Senior', 'Pleno', 'Junior', 'Trainee', 'Estágio', 'Não informado') NOT NULL DEFAULT 'Não informado',
job_salary VARCHAR(255) NOT NULL,
job_currency ENUM('Real', 'Dollar', 'Euro') NOT NULL DEFAULT 'Real',
job_mode ENUM('Remoto', 'Presencial', 'Híbrido', 'Não informado') NOT NULL DEFAULT 'Não informado',
job_contract ENUM('PJ', 'CLT', 'Não listado') NOT NULL DEFAULT 'Não listado',
@SilasRodrigues19
SilasRodrigues19 / estacionamento.c
Last active October 23, 2022 05:07
Simples exemplo de estacionamento em C
#include <stdio.h>
#include <stdlib.h>
#include <conio.h>
#include <string.h>
#include <locale.h>
typedef struct estacionamento ESTACIONAMENTO;
struct estacionamento
{
@SilasRodrigues19
SilasRodrigues19 / regex.js
Created September 23, 2022 04:10
URL RegEx
let urlRegex = /https?:\/\/(www\.)?[-a-zA-Z0-9@:%._\+~#=]{1,256}\.[a-zA-Z0-9()]{1,6}\b([-a-zA-Z0-9()@:%_\+.~#?&//=]*)/g