database:query
Executes a SQL statement directly as argument
Usage:
drupal database:query [arguments] [options]
dbq
sqlqAvailable options
| Option | Details |
|---|---|
--quick | Do not cache each query result, print each row as it is received |
--debug | Prints debugging information and memory and CPU usage statistics when the program exits |
--html | Produce HTML output |
--xml | Produce XML output |
--raw | Special characters are not escaped in the output. |
--vertical | Print query output rows vertically |
--batch | Print results using tab as the column separator, with each row on a new line. With this option, mysql does not use the history file |
Available arguments
| Argument | Details |
|---|---|
query | The SQL statement to execute |
database | Database key from settings.php |
target | Database target from settings.php |
Examples
Send a database query
drupal database:query 'select * from node limit 0,1'