diff options
Diffstat (limited to 'mariadb/mariadb-list-databases')
-rwxr-xr-x | mariadb/mariadb-list-databases | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mariadb/mariadb-list-databases b/mariadb/mariadb-list-databases new file mode 100755 index 0000000..527ec90 --- /dev/null +++ b/mariadb/mariadb-list-databases | |||
@@ -0,0 +1,12 @@ | |||
1 | #!/bin/bash | ||
2 | mariadb -t "$@" <<. | ||
3 | select | ||
4 | @@hostname | ||
5 | , @@server_id | ||
6 | , schema_name | ||
7 | as | ||
8 | 'database' | ||
9 | from | ||
10 | information_schema.schemata | ||
11 | ; | ||
12 | . | ||