automated query for multiple promo codes
Posted: Thu Apr 23, 2009 11:22 am
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
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