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
Forever Free Full-Stack Observability | Grafana Cloud Icon
Forever Free Full-Stack Observability | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
Create free account
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