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: Easy to Use With Enterprise Power. Free Trial Icon
Paessler: Easy to Use With Enterprise Power. Free Trial

A low-code dashboard makes monitoring intuitive for any admin, while scripting and custom sensors give experts full control.

You shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
Get Free Download
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