host     : 'localhost',

    user     : 'root',

    password : 'root',

    database : 'user'
});

if (err) throw err;

connection.query('USE user', function (err) {

    if (err) throw err;

    connection.query('CREATE TABLE IF NOT EXISTS user_info('

        + 'email VARCHAR(30) NOT NULL,'

        + 'username VARCHAR(30) NOT NULL,'

        + 'PRIMARY KEY(username),'

        + 'password VARCHAR(15) NOT NULL'

        +  ')', function (err) {

            if (err) throw err;

        });
});

res.render('users/index',{users: results });

if (err) res.json(err);

res.redirect('/myusers/'+email);

console.log(results);

if (err) res.json(err);

 req.user=row[0];

 console.log(row);

 next();

res.status(err.status || 500);

res.render('error', {

  message: err.message,

  error: err

});

message: err.message,

error: {}

tr

  td User Email:

  td

    input#email(type="email", name="email")

tr

  td Username:

  td

    input#userName(type="text", name="userName")

tr

  td Password:

  td

    input#password(type="password", name="password")

tr

  td

    button(type="submit") Create