Advertisement
bluethundr12

Untitled

May 6th, 2019
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.88 KB | None | 0 0
  1. mysql> LOAD DATA LOCAL INFILE 'C:/Users/tdunphy/Desktop/important_folders/git/aws_scripts/source_files/aws_bills/march-bill-original-2019.csv' INTO TABLE billing_info_test
  2.     -> FIELDS TERMINATED BY ','
  3.     -> ENCLOSED BY '"'
  4.     -> LINES TERMINATED BY '\r\n'
  5.     -> IGNORE 1 LINES
  6.     -> (InvoiceId, PayerAccountId, LinkedAccountId, RecordType, RecordId, ProductName, RateId, SubscriptionId, PricingPlanId, UsageType, Operation, AvailabilityZone, ReservedInstance, ItemDescription, UsageStartDate, UsageEndDate, UsageQuantity, BlendedRate, BlendedCost, UnBlendedRate, UnBlendedCost, ResourceId, Engagement, Name, Owner, Parent);
  7. Query OK, 0 rows affected (1 min 20.88 sec)
  8. Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
  9.  
  10. mysql> select * from billing_info_test ORDER BY ID DESC LIMIT 25 \G
  11. Empty set (0.00 sec)
  12.  
  13. mysql> select * from billing_info_test ORDER BY ID;
  14. Empty set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement