thufir

Untitled

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