Skip to content

Instantly share code, notes, and snippets.

View juliendcode's full-sized avatar

juliendcode

2 followers · 43 following
  • Lyon, FR
View GitHub Profile
@juliendcode
juliendcode / SQL4 Delete
Created November 26, 2018 13:29
SQL Delete
DELETE FROM movie WHERE id='5'
DELETE FROM movie WHERE id>'10'
@juliendcode
juliendcode / SQL3 Q
Created November 26, 2018 08:40
Quete SQL 3
UPDATE movie SET name='Men In Black' WHERE id='5'
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'
UPDATE movie SET comment='' WHERE id='10'
@juliendcode
juliendcode / SQL2 Q
Created November 26, 2018 08:25
quete SQL2
INSERT INTO movie VALUES ('26', 'Bohemian Raphsody','https://www.gravatar.com/avatar/e30e7f1494074ce297e1dae6b65d2061', 'au top!')
INSERT INTO movie (name, poster, comment) VALUES ('gremlins', 'https://www.gravatar.com/avatar/e30e7f1494074ce297e1dae6b65d2061', 'cool')
INSERT INTO movie (name, poster, comment) VALUES ('gremlins', 'https://www.gravatar.com/avatar/e30e7f1494074ce297e1dae6b65d2061', 'cool'), ('gremlins', 'https://www.gravatar.com/avatar/e30e7f1494074ce297e1dae6b65d2061', 'cool'), ('gremlins', 'https://www.gravatar.com/avatar/e30e7f1494074ce297e1dae6b65d2061', 'cool')
INSERT INTO movie (name) VALUES ('contact')
@juliendcode
juliendcode / SQL 1
Last active November 22, 2018 19:34
quete sql1
SELECT * FROM `movie` WHERE 1;
SELECT name FROM `movie` WHERE 1;
SELECT id, poster FROM `movie` WHERE 1;
SELECT poster, comment as avis_spectateur FROM `movie` WHERE 1;
@juliendcode
juliendcode / SecretSentence.java
Created November 14, 2018 08:28
les méthodes avec java
public class SecretSentence {
public static String writeSecretSentence(String motMagiqueUn, String motMagiqueDeux) {
return motMagiqueUn + " s'incline face à " + motMagiqueDeux;
}
public static void main(String[] args) {
String sentence = writeSecretSentence("fire", "water");
@juliendcode
juliendcode / LaDerniereCroisade.java
Last active November 11, 2018 22:36
class LaDerniereCroisade {
public static void main(String[] args) {
String voNameMovie ="Indiana Jones and the Last Crusade";
boolean seenThisMovieBefore = true;
int releaseDate = 1989;
float ratings = 8.3f;
System.out.println(voNameMovie);
System.out.println(seenThisMovieBefore);
System.out.println(releaseDate);
@juliendcode
juliendcode / noe.ts
Last active October 2, 2018 08:57
typescript object
class animaux {
nbPattes: number;
couleur: string;
constructor(lenbPattes, laCouleur) {
this.nbPattes = lenbPattes;
this.couleur = laCouleur;
}
photographier() {
@juliendcode
juliendcode / typescript.ts
Last active September 25, 2018 12:25
typescript quete 1
function hello(name:string):void {
console.log("Hello " + name);
}
var firstName: string = "bob";
hello(firstName);
hello(firstName + " marley");
function concat(a:string, b:string):string {
return a + b;
}
@juliendcode
juliendcode / apifetch.html
Last active September 25, 2018 09:37
http request api fetch
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>OpenWeatherAPI</title>
<link rel="stylesheet" href="">
</head>
<body>
@juliendcode
juliendcode / index.html
Last active September 16, 2018 15:29
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>findThePrecious.com</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO"
crossorigin="anonymous">
<link rel=stylesheet href="style.css">
</head>