Skip to content

Instantly share code, notes, and snippets.

View cormobro's full-sized avatar

cormobro

3 followers · 2 following
View GitHub Profile
@cormobro
cormobro / gist:f6d07edc298abe9e8330fa6bfc188825
Created January 8, 2019 15:12
felix_b_wcs_bruxelles.sql
-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
--
-- Host: localhost Database: felix_b_wcs_bruxelles
-- ------------------------------------------------------
-- Server version 5.7.24-0ubuntu0.18.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@cormobro
cormobro / index.js
Created January 8, 2019 08:40
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const cors = require('cors')
app.use(cors())
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
@cormobro
cormobro / index.js
Last active January 3, 2019 09:56
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const cors = require('cors')
app.use(cors())
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
@cormobro
cormobro / index.html
Created December 18, 2018 10:21
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Counter Redux</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Redux CDN -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.1/redux.min.js"></script>
@cormobro
cormobro / remove.txt
Created December 17, 2018 16:03
(Une requête supprime le film ayant l'ID 5)
DELETE FROM movie
WHERE id='5';
(Une requête supprime tous les films ayant un ID supérieur à 10)
DELETE FROM movie
WHERE id>'10';
@cormobro
cormobro / index.js
Created December 17, 2018 15:53
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const cors = require('cors')
app.use(cors())
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
@cormobro
cormobro / mysql.txt
Last active December 10, 2018 12:58
(Une requête change le nom du film ayant l'ID 5)
UPDATE movie
SET name="Men in Black"
WHERE id='5';
(Une requête change le nom et le poster du film ayant l'ID 8)
UPDATE movie
SET name='Deadpool', poster='https://upload.wikimedia.org/wikipedia/en/thumb/2/23/Deadpool_%282016_poster%29.png/220px-Deadpool_%282016_poster%29.png'
WHERE id='8';
@cormobro
cormobro / mysqlpost.txt
Created December 10, 2018 11:00
(Une requête contient uniquement les colonnes "name", "poster" et "comment")
INSERT INT0 movie (name, poster, comment) VALUES ('interstellar', 'interstellar.jpeg', 'that is a great movie for sure');
(Une requête ne contient pas de noms de colonnes)
INSERT INTO movie VALUES (null, 'interstellar', 'interstellar.jpeg', 'that is a great movie for sure');
(Une requête contient 3 valeurs à ajouter)
INSERT INTO movie (name, poster, comment) VALUES ('simpson', 'simpson.jpeg', 'that is not a great movie'), ('simpson', 'simpson.jpeg', 'that is not a great movie'), ('simpson', 'simpson.jpeg', 'that is not a great movie');
(Une requête contient uniquement la colonne "name")
@cormobro
cormobro / index.js
Created December 10, 2018 10:31
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const cors = require('cors')
app.use(cors())
app.get('/api/movies', (req, res) => {
connection.query('SELECT * from employee', (err, results) => {
@cormobro
cormobro / mySql1.txt
Created December 3, 2018 10:34
(Recuperer tous les films):
SELECT * from `movie`
(Recuperer uniquement les noms des films):
SELECT 'name' from 'movie'
(Recuperer uniquement les noms des films et leur id):
SELECT 'name', 'id' from 'movie'
(Recuperer uniquement les posters et commentaires avce un alias sur commentaires):