sql 회원관리

CREATE DATABASE study_db default CHARACTER SET UTF8;

 

create table user(
  user_num int not null,
  id varchar(12) not null,
  auth int(1) default 2 not null,
  constraint ouser_pk primary key (user_num)
);