Pierre van Male vmalep
vmalep
/ gist:f6455e6f0322097b0148703413b260d7
Created
November 30, 2021 12:58
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
| queries: | |
| SELECT t.name, COUNT(*) AS nb_player | |
| FROM player as p | |
| JOIN team AS t ON p.team_id=t.id | |
| GROUP by t.id | |
| ORDER BY nb_player DESC; | |
| SELECT t.name | |
| FROM player as p | |
| JOIN team AS t ON p.team_id=t.id |
vmalep
/ gist:05fee66e4df2f6192d4f60122524b9f1
Created
December 1, 2021 09:52
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
| const connection = require('./db-config'); | |
| const express = require('express'); | |
| const app = express(); | |
| const Joi = require('joi'); | |
| const port = process.env.PORT || 3000; | |
| connection.connect((err) => { | |
| if (err) { | |
| console.error('error connecting: ' + err.stack); |
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
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8" /> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0" /> | |
| <title>Document</title> | |
| </head> | |
| <body> | |
| <p id="counter-render"></p> | |
| <button id="button-increment">Increment</button> |
OlderNewer