MySQL 명령어 썸네일형 리스트형 [mysql] 그때그때 생각 안나는 명령어들 1. ALTER assign foreign key ALTER TABLE table_name ADD foreign key(column_name) REFERENCES target_table_name(column_name) ON DELETE RESTRICT ON UPDATE RESTRICT; assign primary key ALTER TABLE table_name MODIFY column_name type primary key; add auto increment property ALTER TABLE table_name MODIFY column_name type auto_increment; add not null property ALTER TABLE table_name MODIFY column_name typ.. 더보기 이전 1 다음