database:query

Executes a SQL statement directly as argument

Usage:

drupal database:query [arguments] [options]
dbq

Available 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

Examples

  • Send a database query
    drupal database:query 'select * from node limit 0,1'