Skip to content

Instantly share code, notes, and snippets.

@ShubhamKhairnar

ShubhamKhairnar/validation.txt

Created December 8, 2020 06:45
Show Gist options
  • Save ShubhamKhairnar/da1474f85ca6b2875105f1e6a857c3a7 to your computer and use it in GitHub Desktop.
Save ShubhamKhairnar/da1474f85ca6b2875105f1e6a857c3a7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
validation.txt
mysql> SELECT TABLE_SCHEMA, TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
WHERE CREATE_OPTIONS LIKE '%ENCRYPTION%';
+--------------+------------+----------------+
| TABLE_SCHEMA | TABLE_NAME | CREATE_OPTIONS |
+--------------+------------+----------------+
| databasename | table_name | ENCRYPTION="Y" |
+--------------+------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment