automated query for multiple promo codes

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kabucek
Forum Commoner
Posts: 50
Joined: Thu Sep 04, 2008 2:20 pm

automated query for multiple promo codes

Post 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
cal3igh
Forum Newbie
Posts: 2
Joined: Mon Nov 22, 2010 12:20 am

Re: automated query for multiple promo codes

Post 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.
Post Reply