This is a small mysql query builder using the nodejs mysql driver by felixge.

Sample Usage:

```js
var query_builder = require('query_builder');

var dbconn_default = {
host : 'host',
user : 'user',
pass : 'password',
dbase : 'database_schema'
};

var qb = new query_builder( dbconn_default );

var select_details = {
table : 'table_name',
fields : [ 'field1', 'field2', ... ],
conditions : {
field1 : 'value1',
field2 : 'value2'
}
};

qb.select( select_details, function( err, rows ){
if( err )
console.log( err );
else
console.log( rows );
});
```

By this, we can generate a query something like this:

```sql
SELECT `field1`, `field2` FROM `table_name` WHERE `field1` = 'value1' AND `field2` = 'value2'
```

For more information, visit the github project.
https://github.com/sarahseguenza/nodejs-mysql-query-builder

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow Nodejs MySQL Query Builder

Nodejs MySQL Query Builder Web Site

Other Useful Business Software
Paessler - Monitor Your Whole Network in Minutes Icon
Paessler - Monitor Your Whole Network in Minutes

Auto-discovery finds your devices and deploys pre-configured sensors instantly. No project plan required, just visibility from day one.

Waiting weeks for a monitoring rollout isn't an option when infrastructure doesn't stop running. PRTG's auto-discovery scans your network and suggests from over 200 pre-configured sensor types, so you're watching servers, applications and devices within minutes, not after a multi-week deployment. Enterprise-strength monitoring, without the enterprise complexity. Start your free trial today.
Start Free 30-Day Trial
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Nodejs MySQL Query Builder!

Additional Project Details

Languages

English

Intended Audience

Developers, Information Technology

Programming Language

JavaScript

Database Environment

Other API

Related Categories

JavaScript Database Software, JavaScript Front-Ends, JavaScript Database Engines Servers

Registered

2015-05-05