mQ node

var mq = require('mq-node')({
    host     : 'localhost',
    user     : 'root',
    password : '',
    database : 'players'
});
 
mq.insert('players',{
    player:'Lulu',
    goal:80
}); 
 
// return INSERT INTO players SET player="Lulu", goal=80

mq.query('SELECT 1+1 as s',function(err,data){
    //result data[0]['s'] 2
})

mq.delete('test',{player:'Janna'},function(err,data){
});
 
// return DELETE FROM test where player="Janna"
 
mq.delete('test',{'player:"Janna"','score=100'},function(err,data){
});
 
// return DELETE FROM test where player="Janna" and score=100
 
mq.delete('test','player:"Janna" or score=100',function(err,data){
});
 
// return DELETE FROM test where player="Janna" or score=100

mq.insert('players',{
    player:'Lulu',
    goal:80
}); 
 
// return INSERT INTO players SET player="Lulu", goal=80
 
mq.insert('players',[
    'player="Lulu"',
    'goal=80'
]); 
 
// return INSERT INTO players SET player="Lulu"
 
mq.insert('players','player="Lulu", goal=80'); 
 
// return INSERT INTO players SET player="Lulu"

mq.update('test',{goal:30},{player:'Janna'},function(err,data){
})
 
// return UPDATE test set goal=30 WHERE player="Janna"

mq.select({
    from:'test',
    cols:['player','goal','id'],
    where:{player:'Janna'}
},function(err,data){
})
 
// RETURN SELECT player, goal, id FROM test WHERE player="Janna"
 
// full data attributes
 
mq.select({
    from:'test', // [string or array]
    cols:['player','goal','id'], // [string or array]
    where:{player:'Janna'}, // [string, array or object]
    group:'goal', // [string or array]
    order:'goal DESC', // [string or array]
    limit:'0,10', // [string or array]
    have:'player="Janna"', // [string or array]
},function(err,data){
})