MySQL Forums
Forum List  »  MySQL Administrator

Saving credit card information in MySQL database
Posted by: Akshay Zade
Date: October 07, 2021 10:50PM

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/

Options: ReplyQuote


Subject
Written By
Posted
Saving credit card information in MySQL database
October 07, 2021 10:50PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.