Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE Advice AS a
- SET Fase1 = (SELECT Family FROM Computers_F1 AS c WHERE a.id = c.id)
- ALTER TABLE Active CHANGE `Fase1` `Family` VARCHAR(255)
- UPDATE Advice, Computers_F1
- SET Advice.Fase1 = Computers_F1.Family
- WHERE Advice.Id = Computers_F1.Id;
- UPDATE Advice
- INNER JOIN Computers_F1
- ON Advice.Id = Computers_F1.Id
- SET Advice.Fase1 = Computers_F1.Family;
- UPDATE Advice, Computers_F1
- SET Advice.Fase1 = Computers_F1.Family
- WHERE Advice.Computers_F1_Id = Computers_F1.Id;
- UPDATE Advice, Computers_F1
- SET Advice.Fase1 = Computers_F1.Family
- WHERE Advice.Id = Computers_F1.Advice_Id;
- UPDATE Advice
- INNER JOIN Computers_F1
- ON Advice.Computers_F1_Id = Computers_F1.Id
- SET Advice.Fase1 = Computers_F1.Family;
- UPDATE Advice
- INNER JOIN Computers_F1
- ON Advice.Id = Computers_F1.Advice_Id
- SET Advice.Fase1 = Computers_F1.Family;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement