db:query
Run a raw DB query
warning
Running raw SQL queries can affect your database and should be done with caution, especially in production environments. Always review your queries before execution.
n98-magerun2.phar db:query [--connection=CONNECTION] [--only-command] [--format=FORMAT] [<query>]
Arguments:
| Argument | Description |
|---|---|
query | SQL query |
Options:
| Option | Description |
|---|---|
--connection=CONNECTION | Select DB connection type for Magento configurations with several databases |
--only-command | Print only mysql command. Do not execute |
--format=FORMAT | Output format (currently only csv is supported) |
Examples:
n98-magerun2.phar db:query "select * from store"
n98-magerun2.phar db:query --format=csv "select * from store"