Denigma

mysql alter table add foreign key

Created on June 5, 2012, 10:02 p.m.
Language: en
Category: MySQL
Description:

    ALTER TABLE todos_todo ADD COLUMN owner_id int(11) UNSIGNED DEFAULT NULL;

    ALTER TABLE todos_todo ADD INDEX owner_id (owner_id);

    ALTER TABLE todos_todo ADD CONSTRAINT owner_id FOREIGN KEY(owner_id) REFERENCES todos_todo(id) ON DELETE SET NULL ON UPDATE SET NULL;

URL: http://phpprotip.com/2009/07/mysql-alter-table-add-foreign-key/

Update

Comment on This Data Unit