Create a table

Creating a table

You can create a new table with the following query.

CREATE TABLE `test` (
  `id` int NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

The default character set and title order are utf8mb4 and utf8mb4_general_ci.