barthflo

const connection = require('./config');
const express = require("express");

const port = 3000;
const app = express();

connection.connect(err => {
  if(err){
    console.log('error connecting: ' + err.stack);
    return;

barthflo

const connection = require('./config');
const express = require("express");

const port = 3000;
const app = express();

connection.connect(err => {
  if(err){
    console.log('error connecting: ' + err.stack);
    return;

barthflo

const connection = require('./config');
const express = require("express");

const port = 3000;
const app = express();

connection.connect(err => {
  if(err){
    console.log('error connecting: ' + err.stack);
    return;

barthflo

const connection = require('./config');
const express = require("express");

const port = 3000;
const app = express();

connection.connect(err => {
  if(err){
    console.log('error connecting: ' + err.stack);
    return;

barthflo

 SELECT w.firstname, w.lastname, p.role, t.name FROM wizard w 
 LEFT JOIN player p ON p.wizard_id=w.id 
 LEFT JOIN team t ON p.team_id=t.id 
 ORDER BY t.name;
+-------------+-----------------+--------+------------+
| firstname   | lastname        | role   | name       |
+-------------+-----------------+--------+------------+
| Remus       | Lupin           | NULL   | NULL       |
| Horace      | Slughorn        | NULL   | NULL       |
| Padma       | Patil           | NULL   | NULL       |