Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- csv
- 311064,'Dapple Dandy' Interspecific Plum,0,2010
- 311064,'Dapple Dandy' Interspecific Plum,0,2010
- 311064,'Dapple Dandy' Interspecific Plum,0,2010
- 311064,'Dapple Dandy' Interspecific Plum,0,2010
- mysql command
- mysql> load data infile 'production_estimates.csv' into table production_estimates fields terminated by ',' optionally enclosed by '"' ( grower_number , Cultivar , Estimated_Weight , season ) ;
- Query OK, 5879 rows affected (0.06 sec)
- Records: 5879 Deleted: 0 Skipped: 0 Warnings: 0
- Result now:
- | Sunlit Snow' Peach | 2592 |
- | Sweet Henry' Peach | 330 |
- | Sweet September' Peach | 1980 |
- | Sweet Shasta' Peach | 2240 |
- +-----------------------------------+------------------+
- 31 rows in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement