mysqlusequery v1.3.0

What is this ?

you can now use mysql CURD oparetion very easily

This project is pre-install mysql module

installation

 $ npm i mysqlusequery

Then..

require mysql-query in your project

const mysqlQuery = require("mysqlusequery");

Let's get connection of mysql database

mysqlQuery.getMysqlConnection();

The getMysqlConnection() function takes 5 parameter

• hostname
• username
• password
• databasename
• () callback function
  • (error,connection) callback function have also two parameter

like this...

mysqlQuery.getMysqlConnection("localhost", "root", "3434", "test", (err, conn) => {
  if (err) {
    //code will be here
  }
  else {
    //code will be here
  }
  //connection variable is conn
});

let's insert data in mysql using mysqlusequery

mysqlQuery.insertData()

this insertData() function takes 3 parameter

• tablename of your database
• {} object form of your row and data formate

• () callback function

  • (error,res) res object is a parameter of callback function

like this...

mysqlQuery.insertData("userdata", {
  "rows": "rowsdata",
  "name": "john dow",
  "email": "johndow@gmail.com"
}, (err, res) => {
  if (err) {
    //code will be here
  }
  else {
    //code will be here 
    console.log(res);
  }
});

let's select a or more data from mysql table

mysqlQuery.selectData();

selectData() function takes 4 parameter

• tablename of your database
• "rowname","ohterrowname" pass that rows name where you want to select
• Where condition like id=1,password="something"
• callback function()
  • The callback takes (err,results,field)

let's select all data from mysql table

mysqlQuery.selectAllData()

The selectAllData() function takes two parameter

• tablename tablename of your mysql database
• callback() function
  • callback function takes (err,results,field)

let's delete data form mysql table

mysqlQuery.deleteData();

The deleteData() function takes 3 parameter

• tablename of your database
• condition of rows that you want to delete
• callback() function
  • callback function takes (error,results)

let's deleteAll data from your mysql table

mysqlQuery.deletdataAll();

The deletdataAll() function takes 2 parameter

• tablename of your database
• callback() function
  • callback function takes (error,results);

let's updata data's from mysql tables

mysqlQuery.updateData();

The updateData() function takes 4 parameter

• tablename of your database
• updatadata pass like a string
• where condition
• callback() function
  • callback function takes (error,results);

let's get data by limit

mysqlQuery.getLimitData();

the getLimitData() function takes 4 parameter

• tablename of your database
• select data limit
• pass row if your want to select data in order or pass false
• callback() function
  • callback function takes (error,results,field);

let's get rows data by limit

mysqlQuery.getLimitDataByOne();

the getLimitDataByOne() function takes 6 parameter

• tablename of your database
• rows name in arry formate
• condition of rows those you want to select
• limit number
• pass row if your want to select data in order or pass false
• callback() function
  • callback function takes (error,results,field);

get data by order

mysqlQuery.getOrderdDataAll();

The getOrderdDataAll() function takes 4 parameter

• tablename of your database
• order rows
• pass number of limit or don't want limit pass false;
• callback() function
  • callback function takes (error,results,field);

let's get rows with order

mysqlQuery.getOrderdData();

The getOrderdData() function takes 5 parameter

• tablename
• rows name
• order
• pass a nuber of limit or don't want it pass false
• callback() function
  • callback function takes (error,results,field);