ALTER, FOREIGN KEY, JOIN Version : Mariadb 5.5.4.2-WinX64 테이블 생성 use sw_test; create table user ( uid char(8), name varchar(32), money dec(10,2), score int ); 제일 앞에 uid2 컬럼 추가 alter table user add column uid2 char(8) first; name 컬럼 뒤에 birth 컬럼 추가 alter table user add column birth date after name; Uid에 PRIMARY KEY 속성 추가 alter table user add primary key (uid); Score 컬럼 삭제 alter table user drop col..
