PHPize Online / SQLize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE `register` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO `register` (`id`, `user`, `email`, `gender`) VALUES (1, 'doe', 'doe@example.com', 'male'), (2, 'jane', 'jane@example.com', 'female');