Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- -> FIELDS TERMINATED BY ','
- -> ENCLOSED BY '"'
- -> LINES TERMINATED BY '\r\n'
- -> IGNORE 1 LINES
- -> (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);
- Query OK, 0 rows affected (1 min 20.88 sec)
- Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
- mysql> select * from billing_info_test ORDER BY ID DESC LIMIT 25 \G
- Empty set (0.00 sec)
- mysql> select * from billing_info_test ORDER BY ID;
- Empty set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement