カラムの追加と外部キー制約の追加をそれぞれ行うことがポイント
ALTER TABLE table
ADD id BINARY(16) NOT NULL,
ADD CONSTRAINT table_fk01
FOREIGN KEY (id)
REFERENCES other_table (other_id)
ON DELETE CASCADE
ON UPDATE NO ACTION;
More than 3 years have passed since last update.
カラムの追加と外部キー制約の追加をそれぞれ行うことがポイント
ALTER TABLE table
ADD id BINARY(16) NOT NULL,
ADD CONSTRAINT table_fk01
FOREIGN KEY (id)
REFERENCES other_table (other_id)
ON DELETE CASCADE
ON UPDATE NO ACTION;
Register as a new user and use Qiita more conveniently