Page 1 of 1

automated query for multiple promo codes

Posted: Thu Apr 23, 2009 11:22 am
by kabucek
hello,

I have this query for creating one code at a time

INSERT INTO `database1`.`table1` (
`couponCode`,
`pageCount`
)
VALUES (
'promo-001002', '2'
);

but this will create only one code.
I need a query that will create 200 codes with starting number "-001002".
Is there a way to do it?

Thanks

Re: automated query for multiple promo codes

Posted: Mon Nov 22, 2010 12:31 am
by cal3igh
Before I speak out my little knowledge about your concern, I just have to remind you that it’s human nature to find for bargains or even the lowest prices when buying products. By offering a special discount using a coupon for your customers it will certainly be much well-received as it will give high sales. The Xtreme Coupon Codes 2.0 of the softpedia.com is now in the market intended for this purpose.