database:query
Executes a SQL statement directly as argument
Utilisation:
drupal database:query [arguments] [options]
dbq
sqlqOptions disponibles
| Option | Détails |
|---|---|
--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 |
Paramètres disponibles
| Paramètre | Détails |
|---|---|
query | The SQL statement to execute |
database | Database key from settings.php |
target | Database target from settings.php |
Exemples
Send a database query
drupal database:query 'select * from node limit 0,1'