Hello,
I am trying to store credit card data downloaded from cardgenerators.net[1]. and I have found an issue with invalid formate.
Credit card details are in the below formate -
******************************************************************
CARD DETAILS
1 ) CARD BRAND : AMERICAN EXPRESS
CARD NUMBER : 372383177734282
BANK : AMEX GCS INTL EURO
NAME : Jlia Sherry
ADDRESS : 58 Hart Road
COUNTRY : UNITED KINGDOM
MONEY RANGE : $549
CVV/CVV2 : 4757
EXPIRY (MM/YYYY) : 10/2024
CARD PIN : 4683
2 ) CARD BRAND : AMERICAN EXPRESS
CARD NUMBER : 372383728352584
BANK : AMEX GCS INTL EURO
NAME : Huriyyah Yefremov
ADDRESS : 24 Asfordby Rd
COUNTRY : UNITED KINGDOM
MONEY RANGE : $806
CVV/CVV2 : 4771
EXPIRY (MM/YYYY) : 12/2023
CARD PIN : 2904
3 ) CARD BRAND : AMERICAN EXPRESS
CARD NUMBER : 372383926633371
BANK : AMEX GCS INTL EURO
NAME : Jeppe Yefremov
ADDRESS : 5 Leicester Road
COUNTRY : UNITED KINGDOM
MONEY RANGE : $876
CVV/CVV2 : 5928
EXPIRY (MM/YYYY) : 06/2024
CARD PIN : 5233
4 ) CARD BRAND : AMERICAN EXPRESS
CARD NUMBER : 370024783232053
BANK : AMEX GCS INTL EURO
NAME : Adelajda Shiroi
ADDRESS : 95 Exning Road
COUNTRY : UNITED KINGDOM
MONEY RANGE : $948
CVV/CVV2 : 4932
EXPIRY (MM/YYYY) : 10/2025
CARD PIN : 2332
5 ) CARD BRAND : AMERICAN EXPRESS
CARD NUMBER : 372383994928166
BANK : AMEX GCS INTL EURO
NAME : Lavinia Collin
ADDRESS : 29 High Street
COUNTRY : UNITED KINGDOM
MONEY RANGE : $870
CVV/CVV2 : 6592
EXPIRY (MM/YYYY) : 07/2023
CARD PIN : 3993
******************************************************************
I converted it into CSV format and trying to export it in MySQL database but I am unable to do it.
Can anyone suggest to me how to store this kind of data into MySQL database?
NOTE - Above credit card details are Fake and it is used for data testing, Algorithm testing, and Security check.
Ref:
[1] -
https://www.cardgenerators.org/