Node.js MySQL Create Database
CREATE DATABASE statement is used to create a database in MySQL.
Example
For creating a database named "javatpoint".
Create a js file named javatpoint.js having the following data in DBexample folder.
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "12345"
- });
- con.connect(function(err) {
- if (err) throw err;
- console.log("Connected!");
- con.query("CREATE DATABASE javatpoint", function (err, result) {
- if (err) throw err;
- console.log("Database created");
- });
- });
Now open command terminal and run the following command:
- Node javatpoint.js
You can see the database is created.
Verification
To verify if the database is created or not, use the SHOW DATABASES command. Before this, go to initial path by using mysql-p command.
