7 lines
260 B
MySQL
7 lines
260 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE vn.tagAbbreviation ADD tagFk int(11) DEFAULT NULL;
|
||
|
|
ALTER TABLE vn.tagAbbreviation ADD CONSTRAINT tagAbbreviation_FK FOREIGN KEY (tagFk) REFERENCES vn.tag(id);
|
||
|
|
UPDATE vn.tagAbbreviation
|
||
|
|
SET tagFk=56
|
||
|
|
WHERE value='Rosa';
|