Create a MySQL table using Node.js

Generally speaking, NoSQL databases (such as MongoDB) are more popular among Node developers. However, which database management system you choose depends entirely on your use cases and choices. The type of database you choose depends primarily on the needs of your project.

For example, if you need to create tables or insert and process large amounts of data in real time, a NoSQL database is a good choice; while if your project involves more complex queries and transaction processing, a SQL database is more reasonable.

In this article, we will explain how to connect to MySQL and create a new table in it.

Install NPM MySQL dependencies

Here are the steps to check your application’s connection to the MySQL database.

• Create a project of your choice and navigate to it.

>> mkdir mysql-test
>> cd mysql-test

• Use the following command to create a package.json file

>> npm init -y

You will get The following output −

Wrote to /home/abc/mysql-test/package.json:
{
   "name": "mysql-test",
   "version": "1.0.0",
   "description": "",
   "main": "index.js",
   "scripts": {
      "test": "echo \"Error: no test specified\" && exit 1"
   },
   "keywords": [],
   "author": "",
   "license": "ISC"
}

• Install the MySQL module-

   >> npm install mysql

Output

+ mysql@2.18.1
added 11 packages from 15 contributors and audited 11 packages in 3.264s
found 0 vulnerabilities

Create a MySQL table using Node

• Create a JS file called app.js

• Copy and paste the code snippet given below

• Run the file using the following command

   >> node app.js

Example

// Checking the MySQL dependency in NPM
var mysql = require('mysql');

// Creating a mysql connection
var con = mysql.createConnection({
   host: "localhost",
   user: "yourusername",
   password: "yourpassword",
   database: "mydb"
});

con.connect(function(err) {
   if (err) throw err;
      console.log("Database connected!");
   var sql = "CREATE TABLE students (name VARCHAR(255), address VARCHAR(255))";
   con.query(sql, function (err, result) {
      if (err) throw err;
         console.log("Table created");
   });
});

Output

The following output will be printed on the console:

Database connected!
Table created

The above is the detailed content of Create a MySQL table using Node.js. For more information, please follow other related articles on the PHP Chinese website!