kabucek Posted April 23, 2009 Share Posted April 23, 2009 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 Link to comment https://forums.phpfreaks.com/topic/155377-automated-query-for-multiple-promo-codes/ Share on other sites More sharing options...
fenway Posted April 23, 2009 Share Posted April 23, 2009 Sure... if you have an integers table. Link to comment https://forums.phpfreaks.com/topic/155377-automated-query-for-multiple-promo-codes/#findComment-817727 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.