From 36b447818723ae25d79c3b8250e892ae0fe9af74 Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Wed, 1 Mar 2023 07:45:18 +0100 Subject: Databases --- issues/systems/mariadb/move-to-innodb.gmi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'issues/systems') diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi index 13fecce..72520c5 100644 --- a/issues/systems/mariadb/move-to-innodb.gmi +++ b/issues/systems/mariadb/move-to-innodb.gmi @@ -1027,8 +1027,8 @@ So: ``` show create table TempData; -ALTER TABLE TempData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; ALTER TABLE TempData ENGINE = InnoDB; +ALTER TABLE TempData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; alter table TempData add primary key (Id); show create table TempData; ``` -- cgit v1.2.3