Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. UPDATE Advice AS a
  2. SET Fase1 = (SELECT Family FROM Computers_F1 AS c WHERE a.id = c.id)
  3.  
  4. ALTER TABLE Active CHANGE `Fase1` `Family` VARCHAR(255)
  5.  
  6. UPDATE Advice, Computers_F1
  7. SET Advice.Fase1 = Computers_F1.Family
  8. WHERE Advice.Id = Computers_F1.Id;
  9.  
  10. UPDATE Advice
  11. INNER JOIN Computers_F1
  12. ON Advice.Id = Computers_F1.Id
  13. SET Advice.Fase1 = Computers_F1.Family;
  14.  
  15. UPDATE Advice, Computers_F1
  16. SET Advice.Fase1 = Computers_F1.Family
  17. WHERE Advice.Computers_F1_Id = Computers_F1.Id;
  18.  
  19. UPDATE Advice, Computers_F1
  20. SET Advice.Fase1 = Computers_F1.Family
  21. WHERE Advice.Id = Computers_F1.Advice_Id;
  22.  
  23. UPDATE Advice
  24. INNER JOIN Computers_F1
  25. ON Advice.Computers_F1_Id = Computers_F1.Id
  26. SET Advice.Fase1 = Computers_F1.Family;
  27.  
  28. UPDATE Advice
  29. INNER JOIN Computers_F1
  30. ON Advice.Id = Computers_F1.Advice_Id
  31. SET Advice.Fase1 = Computers_F1.Family;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement