query-database

0.0.6 • Public • Published

query-database

Execute a query that runs in all columns of all tables and return the tables, columns and rows.

Like Ctrl+Shift+F in some code editors, but with a database.

Examples

Find all tables containing "Michael" in any row in any column and list for each table the colums and for each column the rows containing "Michael."

query-database -D sakila -w '`x` like "%Michael%"'

Same thing but using another name to reference the column

query-database -D sakila -c 'column' -w '`column` like "%Michael%"'

Install

npm install -g query-database

/query-database/

    Package Sidebar

    Install

    npm i query-database

    Weekly Downloads

    1

    Version

    0.0.6

    License

    ISC

    Unpacked Size

    5 kB

    Total Files

    6

    Last publish

    Collaborators

    • adriancuadrado