Skip to content

Instantly share code, notes, and snippets.

mysql> INSERT INTO school (name, country, capacity) VALUES ('Ilvermorny School of Witchcraft and Wizardry', 'USA', 300), ('Koldovstoretz', 'Russia', 125), ('Mahoutokoro School of Magic', 'Japan', 800), ('Uagadou School of Magic','Uganda',350);
mysql> UPDATE school SET country='Sweden' WHERE id=4;
mysql> UPDATE school SET capacity=700 WHERE id=7;
mysql> DELETE FROM school WHERE name LIKE '%Magic%';
+----+----------------------------------------------+----------+----------------+
+----+-----------+------------+------------+-------------+-------------------------------------------------------------+-----------+
| 1 | harry | potter | 1980-07-31 | london | | 0 |
| 2 | hermione | granger | 1979-09-19 | | Friend of Harry Potter | 0 |
| 3 | lily | potter | 1960-01-30 | | mother of Harry Potter | 0 |
| 4 | ron | weasley | 1980-03-01 | | Best friend of Harry | 0 |
| 5 | ginny | weasley | 1981-08-11 | | Sister of Ron and girlfriend of Harry | 0 |
| 6 | fred | weasley | 1978-04-01 | | | 0 |
| 7 | george | weasley | 1978-04-01 | |
@mehdihettak
mehdihettak / README.md
Created April 20, 2019 16:29 — forked from JamesMenetrey/README.md
Install Oh-My-Zsh + iTerm2 with Solarized + System-wide console in 2017 (macOS)

Install iTerm2 with Solarized in 2017

Here is the looks and feel of your terminal once the tutorial has been applied on your system:

Install iTerm2

Using Homebrew:

#!/bin/bash
echo "Bonjour, quel est votre nom : $nom"
read nom
echo "Salut $nom."
interface FourLegs {
readonly fourLeg: true;
}
interface Black {
readonly black: true;
}
class Animal {
}
function hello(name) {
console.log("Hello " + name);
}
var firstName = "bob";
hello(firstName);
hello(firstName + " marley");
function concat(a, b) {
return a + b;
}
var wcs = concat("Wild", concat("Code", "School"));
const assert = require('assert');
// ... Ton code ici ...
class BankCustomer {
constructor(name, code) {
let codeSecret = code;
let nameSecret = name;
var cowsay = require("cowsay");
console.log(cowsay.say({
text : "hello boy",
e : "oO",
T : "U "
}));
process.stdin.resume()
process.stdin.setEncoding('utf8')
console.log('how old are you ? ')
process.stdin.on('data', (num) => {
const year = 2019
if (num > 99) {
console.log('too late!')
class person {
constructor(name, age) {
this.age = age;
this.name = name
}
tellMyAge() {
console.log(`I am ${this.age} years old`)
}