drush sql:queryfor drush 9x
Execute a query against a database.
drush sql:query
-
Aliases
sql:query has 2 alias/es:
drush sqlq
drush sql-query
-
Arguments
sql:query accepts 1 argument/s:
query : An SQL query. Ignored if --file is provided.
-
Options
sql:query accepts 10 option/s:
--result-file
--result-file : result-file
--file
--file : file
--extra
--extra : extra
--db-prefix
--db-prefix : db-prefix
--database
--database : database
--target
--target : target
--db-url
--db-url : db-url
--notify
--notify : notify
--druplicon
--druplicon : druplicon
--xh-link
--xh-link : xh-link
-
Examples
Browse user record. Table prefixes, if used, must be added to table names by hand.
drush sql:query "SELECT * FROM users WHERE uid=1"
Browse user record. Table prefixes are honored. Caution: All curly-braces will be stripped.
drush sql:query --db-prefix "SELECT * FROM {users}"
Import sql statements from a file into the current database.
`drush sql-connect` < example.sql
Alternate way to import sql statements from a file.
drush sql:query --file=example.sql
-
Comments
comments powered by Disqus