MySQL ENCRYPTION AT REST

MySQL ENCRYPTION AT REST is a SQL statement in the MySQL Specific category. MySQL 8.0+: InnoDB tablespace encryption for data at rest. Requires keyring plugin. The syntax is ALTER TABLE t ENCRYPTION = 'Y';. It returns encrypted table created. A close relative is AUTO_INCREMENT, which mySQL auto-generates sequential integer values for this column. Commonly used with PRIMARY KEY. A close relative is ENGINE, which specifies the MySQL storage engine. InnoDB (default) supports transactions and foreign keys. MyISAM is faster for read-heavy. A close relative is LAST_INSERT_ID(), which returns the AUTO_INCREMENT value generated by the most recent INSERT in the current connection. More about this category: MySQL-specific features — AUTO_INCREMENT, ENGINE, SHOW TABLES, LIMIT. Related MySQL Specific entries: AUTO_INCREMENT, ENGINE, LAST_INSERT_ID(), ON DUPLICATE KEY UPDATE, LOAD DATA INFILE, LOCK TABLES / UNLOCK TABLES, FIND_IN_SET(), CHARACTER SET / COLLATION. This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.