Home >>Nodejs Tutorial >Node.Js Create Connection with MySQL

Node.Js Create Connection with MySQL

« Previous Next »

Node.js MySQL Create Database

The statement CREATE DATABASE is used for creating a MySQL database.

Example For creating a database named "Student".

Creating a javascript file called "connection.js" with the following data in the folder example1.


var db = require('db');  
var con = db.createConnection({  
host: "localhost",  
user: "root",  
password: ""  
});  
con.connect(function(err) {  
if (err) throw err;  
console.log("Connected!");  
con.query("CREATE DATABASE Student", function (err, result) {  
if (err) throw err;  
console.log("Database created");  
});  
});

Now open the command terminal and execute the following command:

Node connection.js

The database is built for you to use.

Verification

To check whether or not the database is created use the command SHOW DATABASES. Before this, use mysql-p command to go to initial route.

« Previous Next »

Nodejs Tutorial Nodejs - Environment Setup Node.js First Example Node.js REPL Node.js Package Manager(NPM) Node.js Command Line Options Node.js Global Objects Node.js OS Node.js Callbacks Concept Node.js Timer Node.js Errors Node.js Events Node.js - Event Emitter Node.js - Buffers Node.js - Streams Node.js - File System Node.js - Utility Modules Node.js - Web Module Node.js - Express Framework Node.js - RESTful API Node.js - Scaling Application Node.js - Packaging Node.js Query String Node.js Assertion Testing Node.Js Create Connection with MySQL Node.js MySQL Create Database Node.js MySQL Create Table Node.js MySQL Insert Records Node.js MySQL Update Records Node.js MySQL Select Records Node.js MySQL SELECT Unique Record Node.js MySQL Delete Records Node.js MySQL Drop Table Difference between Node.js and AngularJS Difference between Node.js and PHP Difference between Node.js and Python Difference between Node.js and Java

Node.js Interview Questions and Answers

No Sidebar ads