-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathGiftCardSQLQuery-demo.sql
50 lines (50 loc) · 6.1 KB
/
GiftCardSQLQuery-demo.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '0524-4305-6502-9', '499716', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1346-6008-2866-4', '183814', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8432-6058-7024-6', '589904', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8126-1599-7541-9', '738091', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '9545-3266-2360-9', '266605', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '0409-7751-3255-8', '630699', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '3302-6856-4875-7', '926966', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '5155-0595-0583-4', '701551', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '4712-9687-6587-9', '406146', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '6386-1371-1679-2', '833645', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '9522-4213-1486-0', '851461', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8839-2266-8121-3', '487772', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8161-7228-3785-2', '722451', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1004-1580-6012-3', '356661', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '5884-3209-6940-6', '169840', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '2328-1580-2710-0', '866724', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '5744-2288-9598-0', '881032', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '9231-7317-3177-1', '605388', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '0456-0403-8962-6', '676996', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '3239-8893-2366-2', '828682', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '6339-4804-2887-1', '502230', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '4506-5485-1498-6', '647008', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '6652-7083-3751-1', '781712', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8061-8075-7889-8', '302061', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1525-4263-3056-9', '624553', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '9328-6065-9374-9', '846452', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '2140-9164-8308-6', '875354', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1465-5240-9413-6', '684956', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1017-0756-9546-8', '984060', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '3340-3391-5229-8', '656914', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '2508-2658-2336-3', '498121', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '5660-7494-3566-5', '574373', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1966-3064-6971-4', '433379', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8636-8761-8598-9', '321778', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '5638-4889-8809-5', '605496', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '4099-5907-9833-0', '367266', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '1843-0467-1716-2', '100161', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '6432-8917-6047-2', '118228', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '3326-4676-3374-6', '453344', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8152-9285-0530-0', '240155', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '8270-9400-8359-5', '617925', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '7195-5931-2983-2', '727498', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '3589-3469-5896-4', '980221', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '0387-2662-5398-2', '385424', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '6842-2682-8296-3', '521323', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '9547-4330-0844-9', '192557', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '0903-9218-4712-6', '848465', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '5235-3569-4883-5', '774749', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '0902-2584-5537-1', '411462', 'Inactive');
INSERT INTO GiftCard (IDPRODUCT, GIFTCARDNUMBER, GIFTCARDPIN, STATUS) VALUES (10, '9392-2721-7030-5', '730427', 'Inactive');