Node.js - MySQL TRUNCATE

In this post, we will discuss how to delete all the rows from MySQL XAMPP Server using Node.js with TRUNCATE Command.

It is important to install mysql package in node.js

Command to install the mysql package:

CopiedCopy Code
npm install mysql
				
Steps:

Now let's see steps

  1. First start your XAMPP Server (Both Apache and MySQL).
  2. Open Notepad or any text-editor and write the Node.js script
  3. In that script, first we have to load the mysql package using the below syntax
  4. var mysql_package = require('mysql');
  5. Create the connection using the server,username and password.
  6. CopiedCopy Code
    
    var connection_data = mysql_package.createConnection({
      host: "localhost",
      user: "root",
      password: "",
      database:"database_name"
    });
    
  7. Write the sql query that uses TRUNCATE command
  8. CopiedCopy Code
    
    connection_data.connect(function(error) {
      var delete_query = "TRUNCATE TABLE table_name";
      connection_data.query(delete_query, function (error, result) {	  
        console.log("All rows deleted Successfully!");
    });
    });
  9. Now type the following command in your command prompt to run the script.
  10. node file_name.js

Consider the field table with the following records:

alt=

TRUNCATE Example:-

Let's delete all rows from field.

CopiedCopy Code

// Load the mysql package
var mysql_package = require('mysql');

// Create the connection using the server,username and password.
//In my scenario - server is the localhost,
//username is root,
//password is empty.
//database is facility
var connection_data = mysql_package.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database:"facility"
});

connection_data.connect(function(error) {
	// Delete all records in field table.
  var delete_query = "TRUNCATE TABLE field";
  connection_data.query(delete_query, function (error, result) {	  
    console.log("All rows deleted Successfully!");
});
});

Output:

CopiedCopy Code

All rows deleted Successfully!

Let's check in our XAMPP Server whether all the rows deleted or not.

alt= Summary

In this post, we seen how to delete all the rows from mysql table with TRUNCATE Command using Node.js script in XAMPP Server.