[3] 테이블 생성

1. localhost:8080/h2-console 로 접속

DDL

 

CREATE TABLE IF NOT EXISTS USERS
(
   USER_NO int NOT NULL AUTO_INCREMENT,
   ID varchar(50) NOT NULL, 
   PW varchar(50) NOT NULL,
   NAME varchar(10) NOT NULL,
  PRIMARY KEY(USER_NO)
);

DML

INSERT INTO USERS (ID, PW, NAME) VALUES('TEST1', '1111', 'KIM');