來一份鐵板燒仙草吧！

CREATE SCHEMA `myweb` DEFAULT CHARACTER SET utf8 ;

// 新增一個資料庫

CREATE TABLE `myweb`.`member_t` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(45) NOT NULL,
  `password` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
//新增一個資料表，資料行

INSERT INTO `myweb`.`member_t` (`id`, `username`, `password`) VALUES ('1', 'admin', 'admin');
INSERT INTO `myweb`.`member_t` (`id`, `username`, `password`) VALUES ('2', 'debra', 'debra');
INSERT INTO `myweb`.`member_t` (`id`, `username`, `password`) VALUES ('3', 'milssove', '123');
//新增資料列