Advertisement
Guest User

Untitled

a guest
Sep 16th, 2014
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. LOAD DATA LOCAL
  2. INFILE '/Users/Farmor/data.sql'
  3. INTO TABLE tablename
  4. COLUMNS TERMINATED BY 'n';
  5.  
  6. COPY tablename
  7. FROM '/Users/Farmor/data.sql'
  8. WITH DELIMITER 'n'
  9.  
  10. COPY tablename
  11. FROM '/Users/Farmor/data.sql'
  12. WITH DELIMITER E'n'
  13.  
  14. COPY tablename
  15. FROM '/Users/Farmor/data.sql'
  16. WITH DELIMITER '~';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement