建表
CREATE TABLE `user` (
`id` INT NULL DEFAULT NULL,
`username` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`password` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci'
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
初始化数据
INSERT INTO `user` (`id`, `username`, `password`) VALUES (1, 'lilei', '123456');
INSERT INTO `user` (`id`, `username`, `password`) VALUES (2, 'hanmeimei', '123456');