• PHP Training
    •  
  • Login/Register

    • Home >>Nodejs Tutorial >Node.js MySQL Drop Table

    Node.js MySQL Drop Table

    « Previous Next »

    Node.js MySQL Drop Table

    The command DROP TABLE helps to delete or remove a table.

    Let's drop a table called users.

    In example1 folder, build a js file called "drop.js" and put the following data into it:

    Example 
    
var db = require('db');  
var con = db.createConnection({  
host: "localhost",  
user: "root",  
password: "",  
database: "phptpoint"  
});  
con.connect(function(err) {  
if (err) throw err;  
var sql = "DROP TABLE users";  
con.query(sql, function (err, result) {  
if (err) throw err;  
console.log("Table deleted");  
});  
});

    Now open terminal command and execute the following instruction:

    Node drop.js
    « 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