Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. INSERT INTO CUSTOMERS ( Company, Name, Phone_1, Address_1, City, State, Zipcode, Marketing, Phone, Code )
  2. SELECT Company, Name, Phone_1, Address_1, City, State, Zipcode, Marketing, Phone, Code FROM IMPORT
  3. ON DUPLICATE KEY UPDATE Company=VALUES(Company), Name=VALUES(Name), Address_1=VALUES(Address_1),
  4. City=VALUES(City), State=VALUES(State), Zipcode=VALUES(Zipcode), Marketing=VALUES(Marketing),Phone=VALUES(Phone), Code=VALUES(Code);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement