thufir

Untitled

Jun 23rd, 2014
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. thufir@dur:~$
  2. thufir@dur:~$ mysql -u root -p
  3. Enter password:
  4. Welcome to the MySQL monitor. Commands end with ; or \g.
  5. Your MySQL connection id is 62
  6. Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)
  7.  
  8. Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
  9.  
  10. Oracle is a registered trademark of Oracle Corporation and/or its
  11. affiliates. Other names may be trademarks of their respective
  12. owners.
  13.  
  14. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  15.  
  16. mysql>
  17. mysql> LOAD DATA INFILE '/home/thufir/make_year_model.csv' INTO TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
  18. ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found (Errcode: 13)
  19. mysql>
  20. mysql> quit
  21. Bye
  22. thufir@dur:~$
  23. thufir@dur:~$ cat /home/thufir/make_year_model.csv
  24.  
  25. make1,model1,2012,604,buy now
  26. make2,model2,2013,780,need to sell
  27. make3,model3,2001,780,cheap
  28.  
  29. thufir@dur:~$
Advertisement
Add Comment
Please, Sign In to add comment