UPDATE user_cat C SET rec_nums=(select count(*) from user WHERE catid regexp C.catid);Table 'okgoodco_trade20140106.user_cat' doesn't exist