SHOW SHADOW ALGORITHMS
Description
The SHOW SHADOW ALGORITHMS syntax is used to query shadow algorithms for specified database.
Syntax
ShowShadowAlgorithm::=
'SHOW' 'SHADOW' 'ALGORITHMS' ('FROM' databaseName)?
databaseName ::=
identifierSupplement
- When
databaseNameis not specified, the default is the currently usedDATABASE. IfDATABASEis not used,No database selectedwill be prompted.
Return value description
| Column | Description |
|---|---|
| shadow_algorithm_name | Shadow algorithm name |
| type | Shadow algorithm type |
| props | Shadow algorithm properties |
| is_default | Default |
Example
- Query shadow algorithms for specified database.
SHOW SHADOW ALGORITHMS FROM shadow_db;mysql> SHOW SHADOW ALGORITHMS FROM shadow_db;
+-------------------------+-------------+-----------------------------------------+------------+
| shadow_algorithm_name | type | props | is_default |
+-------------------------+-------------+-----------------------------------------+------------+
| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false |
+-------------------------+-------------+-----------------------------------------+------------+
1 row in set (0.00 sec)- Query shadow algorithms for current database.
SHOW SHADOW ALGORITHMS;mysql> SHOW SHADOW ALGORITHMS;
+-------------------------+-------------+-----------------------------------------+------------+
| shadow_algorithm_name | type | props | is_default |
+-------------------------+-------------+-----------------------------------------+------------+
| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false |
+-------------------------+-------------+-----------------------------------------+------------+
1 row in set (0.00 sec)Reserved word
SHOW, SHADOW, ALGORITHMS, FROM