Creating a database in MySQL using node.js

Question

I'm following a tutorial that requires me to create a database, normally i would have created this through phpmyadmin but i obviously can't do this. The following is the script required, i've tried the create line on my command line but it doesn't seem to work. Where do i run the database script? I'm using npm, and using my windows command line

create database test;

use test;

CREATE TABLE users (
  id int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL,
  age int(3) NOT NULL,
  email varchar(100) NOT NULL,
  PRIMARY KEY (id)
);

Momen Zalabany · Accepted Answer · 2019-08-24 00:40:14Z

2

you dont have to specify database to connect to server.

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  multipleStatements: true // this allow you to run multiple queries at once.
});

var sqlCommand = `
create database test;

use test;

CREATE TABLE users (
  id int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL,
  age int(3) NOT NULL,
  email varchar(100) NOT NULL,
  PRIMARY KEY (id)
);
`
con.connect(function(err) {
  if (err) throw err;
  console.log("Connected yet no db is selected yet!");
  con.query("CREATE DATABASE users", function (err, result) {
    if (err) throw err;
    console.log("Database created");
  });
// OR allow multiple queries in createConnection and run
// con.query(sqlCommand, function (err, result) {
//    if (err) throw err;
//    console.log("Database created");
//  });

});

edited Aug 24, 2019 at 0:40

answered Aug 24, 2019 at 0:13

Momen Zalabany

9,03616 gold badges81 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ankitkhandelwal185 · Accepted Answer · 2018-04-10 12:02:38Z

-1

it can be done using nodejs file, follow this code to create database in mysql

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword",
  database: "dbname"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255))";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("Table created");
  });
});

answered Apr 10, 2018 at 12:02

ankitkhandelwal185

1,1311 gold badge16 silver badges24 bronze badges

3 Comments

user9562782 Over a year ago

Thankyou, i'm following the tutorial at blog.chapagain.com.np/… Step 12 runs the create database line, it would seem like he uses the command line, is this the case?

ankitkhandelwal185 Over a year ago

I think he missed that part to include in js file, you can add this table creation part there

deathangel908 Over a year ago

How is that supposed to create database when you're specifying 'database' in your config file? You simply will receive Unknown database 'dbname'.

Collectives™ on Stack Overflow

Creating a database in MySQL using node.js

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related