使用示例 本页介绍全密态的使用示例。 plaintext 创建CMK主秘钥 CREATE CLIENT MASTER KEY cmk12 WITH ( KEYSTORE localkms, KEYPATH "localkms1" , ALGORITHM SM2); CREATE CLIENT MASTER KEY cmk2 WITH ( KEYSTORE localkms, KEYPATH "localkms1" , ALGORITHM SM2); 创建CEK数据秘钥 CREATE COLUMN ENCRYPTION KEY cek1 WITH VALUES ( CLIENTMASTERKEY cmk1, ALGORITHM SM4SM3); CREATE COLUMN ENCRYPTION KEY cek2 WITH VALUES ( CLIENTMASTERKEY cmk2, ALGORITHM SM4SM3); DROP CLIENT MASTER KEY cmk1 CASCADE; 创建加密表,col1未加密,col2使用cek1加密,col3和col4使用cek2加密 CREATE TABLE IF NOT EXISTS tbl1 ( col1 INT, col2 INT ENCRYPTED WITH ( COLUMNSENCRYPTIONKEY cek1, ENCRYPTIONTYPE DETERMINISTIC), col3 TEXT ENCRYPTED WITH ( COLUMNSENCRYPTIONKEY cek2, ENCRYPTIONTYPE DETERMINISTIC), col4 VARCHAR(20) ENCRYPTED WITH ( COLUMNSENCRYPTIONKEY cek2, ENCRYPTIONTYPE DETERMINISTIC) );