CREATE TABLE IF NOT EXISTS `classmate` (
  `schnum` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `gender` enum('b','g') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'g',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `classmate` (`schnum`, `name`, `gender`, `email`) VALUES
('D10416222', '»¯¤p¤û', 'g', 'xyz@gmail.com'),
('D10416288', '¶À¤p½Þ', 'b', 'pig@yahoo.com.tw');