Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS target;
- DROP TABLE IF EXISTS source;
- CREATE TABLE source (
- id INT UNSIGNED NOT NULL PRIMARY KEY,
- name VARCHAR(255)
- ) ENGINE=InnoDB;
- CREATE TABLE target (
- id INT UNSIGNED NOT NULL PRIMARY KEY,
- source_id INT UNSIGNED NOT NULL
- ) ENGINE=InnoDB;
- ALTER TABLE target ADD CONSTRAINT FOREIGN KEY (source_id) REFERENCES source(id);
- INSERT INTO source VALUES (1, "test");
- INSERT INTO target VALUES (1, 1);
- /* Не работает, ибо есть связанная запись в target, а REPLACE делает DELETE + INSERT */
- REPLACE INTO source VALUES (1, "new test");
Add Comment
Please, Sign In to add comment