search

practice / blog

For personal blogging
1 stars 0 forks source link

mysql notes #16

Open practice opened 9 years ago

practice commented 9 years ago

http://egloos.zum.com/kwon37xi/v/1635464 참고

column 수정
ALTER TABLE users MODIFY username varchar(36) not null unique;
column 추가
ALTER TABLE users ADD type CHAR(1) DEFAULT 'U' NOT NULL;