query-mechanic
v1.0.2
Published
MySQL/SQL Query string builder. Creates an object that connects to your database in a single line of code. That same object comes with methods that makes accessing, and storing data a much simpler endover. Its probably not the best choice for complex sql
Downloads
8
Maintainers
katanadevelopmentReadme
SQLJS
NodeJS Query Builder
- DEVELOPER: Ajay Chambers
- COMMENTS: [email protected]
- Created: 2020-06-26
- Updated: 2020-06-26
Dependancies (x11)
- mysql @ NPM
- core-util-is
- inherits
- isarray
- process-nextick-args
- bignumbers.js
- readable-stream
- safe-buffer
- sqlstring
- string_decoder
- util-deprecate
ABOUT:
SQL_JS is a 'JavaScript Module' located @ Github &/or NPM. The module is a query builder. I created it, becuase I personaly felt I could make a query builder that would serve my purposes better than the other Query Builder Modules on NPM. That is not to say that I feel I have built the worlds greatest query builder, however for my purposes it is the best. I decided to publicize it, maybe someone else will find it usefull. If you do try it please email me and let me know what you think. I am by all means a Junior Developer, and am starting to build some really cool stand alone modules/apps and would really like insight and feedback from anyone will to give it.
Instruction Manule:
Methods:
activate_insertQry(tableName, tableStructure, values)
activate_selectQry(OPTION)
OPTION 1: Query Entire Table
|================( -EXAMPLE- )========================================|
=1=
=2=
=3=
=4=
|=====================================================================|
OPTION 2: Query Entire Column
|================( -EXAMPLE- )========================================|
=1=
=2=
=3=
=4=
|=====================================================================|
OPTION 3: Query Entire Row
|================( -EXAMPLE- )========================================|
=1=
=2=
=3=
=4=
|=====================================================================|
OPTION 4: Query value in a specifiv column at a specific row.
|================( -EXAMPLE- )========================================|
=1=
=2=
=3=
=4=
|=====================================================================|
OPTION 5:
|================( -EXAMPLE- )========================================|
=1=
=2=
=3=
=4=
|=====================================================================|