can we update primary key using Yii.

I have table with:




CREATE TABLE tbl_xyz(

    name VARCHAR(200) NOT NULL,

    is_special BOOLEAN NOT NULL DEFAULT FALSE,

    CONSTRAINT pk_xyz PRIMARY KEY (name)

);


CREATE TABLE tbl_xyz1(

    name VARCHAR(200) NOT NULL,

    group_id INT NOT NULL,

    CONSTRAINT pk_xyz1 PRIMARY KEY (name),

    CONSTRAINT fk_xyz1 FOREIGN KEY (name) REFERENCES tbl_xyz (name) ON DELETE CASCADE

);



How can i update a primary key ?

i.e.

I have 1 record in tbl_xyz:

name => abc

and i want to update "abc" to "abcd" where as abc is foreign key in tbl_xyz1.

Once i update row in tbl_xyz then tbl_xyz1 with "abc" as foreign key should also change to "abcd";

Try to add CONSTRAINT fk_xyz2 FOREIGN KEY (name) REFERENCES tbl_xyz (name) ON UPDATE CASCADE. I think it should be a thing you are looking for.