Node.js MySQL Drop Table (original) (raw)
Last Updated : 07 Oct, 2021
DROP TABLE Query is used to Delete or Drop a table from MySQL Database.
Syntax:
- This will delete users table. But this will throw error if users table is not there.
DROP TABLE users - This will delete users table only if it exist.
DROP TABLE IF EXISTS users
Modules:
- mysql: To handle MySQL connection and Queries
npm install mysql
SQL gfg_db Database Preview (showing tables):
Example 1: Delete users Table
Javascript
const mysql = require( "mysql" );
let db_con = mysql.createConnection({
`` host: "localhost" ,
`` user: "root" ,
`` password: '' ,
`` database: 'gfg_db'
});
db_con.connect((err) => {
`` if (err) {
`` console.log( "Database Connection Failed !!!" , err);
`` return ;
`` }
`` console.log( "We are connected to gfg_db database" );
`` let query = 'DROP TABLE users' ;
`` db_con.query(query, (err, rows) => {
`` if (err) throw err;
`` console.log( 'Deleted users Table' );
`` });
});
Output:
Example 2: Delete users Table only if it Exists
Javascript
const mysql = require( "mysql" );
let db_con = mysql.createConnection({
`` host: "localhost" ,
`` user: "root" ,
`` password: '' ,
`` database: 'gfg_db'
});
db_con.connect((err) => {
`` if (err) {
`` console.log( "Database Connection Failed !!!" , err);
`` return ;
`` }
`` console.log( "We are connected to gfg_db database" );
`` let query = 'DROP TABLE IF EXISTS users' ;
`` db_con.query(query, (err, rows) => {
`` if (err) throw err;
`` console.log( 'Deleted users Table' );
`` });
});
Output:
