Results 1 to 3 of 3
Jan 15, 2013, 05:09 #1
- Join Date
- Dec 2007
- 0 Post(s)
- 0 Thread(s)
MySql do an increment based on country code
I have this table built like this, which assigns a unique articleId starting with zero for each user.
CREATE TABLE `articles` ( `artcId` INT(10) NOT NULL AUTO_INCREMENT, `artcUserId` INT(10) NOT NULL DEFAULT '0', `artcStackId` INT(10) NOT NULL DEFAULT '0', `artcTitle` VARCHAR(200) NULL DEFAULT NULL, PRIMARY KEY (`artcUserId`, `artcId`) ) COLLATE='utf8_general_ci' ENGINE=MyISAM;
Thing is, is it somehow possible to assign a artcStackId based on the country of the user? That country code will come from php.
Eg: If it's US then start from 10001+1, if its UK start from 20001+1, if its CA then start from 30001+1 and on & on.
Will it be possible to do this?
My current SQL query goes as follows:
insert into articles (artcUserId,artcStackId,artcCountry,artcTitle) select 4,IFNULL((MAX(artcStackId)+1) ,0),'US','Hello World' FROM articles;
insert into articles (artcUserId,artcStackId,artcCountry,artcTitle) select 4,IF artcCountry = 'US' then(selct MAX(artcStackId)+1 where artcCountry = 'US'),'US','Hello World' FROM articles;