SHOW DEFAULT SHADOW ALGORITHM
Description
The SHOW DEFAULT SHADOW ALGORITHM syntax is used to query default shadow algorithm for specified database.
Syntax
ShowDefaultShadowAlgorithm::=
'SHOW' 'DEFAULT' 'SHADOW' 'ALGORITHM' ('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 |
Example
- Query default shadow algorithm for specified database.
SHOW DEFAULT SHADOW ALGORITHM FROM shadow_db;mysql> SHOW DEFAULT SHADOW ALGORITHM FROM shadow_db;
+-------------------------+-------------+-----------------------------------------+
| shadow_algorithm_name | type | props |
+-------------------------+-------------+-----------------------------------------+
| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 |
+-------------------------+-------------+-----------------------------------------+
1 row in set (0.00 sec)- Query default shadow algorithm for current database.
SHOW DEFAULT SHADOW ALGORITHM;mysql> SHOW DEFAULT SHADOW ALGORITHM;
+-------------------------+-------------+-----------------------------------------+
| shadow_algorithm_name | type | props |
+-------------------------+-------------+-----------------------------------------+
| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 |
+-------------------------+-------------+-----------------------------------------+
1 row in set (0.00 sec)Reserved word
SHOW, DEFAULT,SHADOW, ALGORITHM, FROM