Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
483
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. csv
  2.  
  3. 311064,'Dapple Dandy' Interspecific Plum,0,2010
  4. 311064,'Dapple Dandy' Interspecific Plum,0,2010
  5. 311064,'Dapple Dandy' Interspecific Plum,0,2010
  6. 311064,'Dapple Dandy' Interspecific Plum,0,2010
  7.  
  8. mysql command
  9.  
  10. mysql> load data infile 'production_estimates.csv' into table production_estimates fields terminated by ',' optionally enclosed by '"' ( grower_number , Cultivar , Estimated_Weight , season ) ;
  11. Query OK, 5879 rows affected (0.06 sec)
  12. Records: 5879 Deleted: 0 Skipped: 0 Warnings: 0
  13.  
  14. Result now:
  15.  
  16. | Sunlit Snow' Peach | 2592 |
  17. | Sweet Henry' Peach | 330 |
  18. | Sweet September' Peach | 1980 |
  19. | Sweet Shasta' Peach | 2240 |
  20. +-----------------------------------+------------------+
  21. 31 rows in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement