â
ã¦ã
ã¢ã¤ã¢ãã¤ã«ï¼i-mobileï¼ã®åçããã¡ãä¸ãã£ã¨ã件
i-mobile(ã¢ã¤ã¢ãã¤ã«)ã®åçãæ°å¹´åã¨æ¯ã¹ã¦
ã¯ãªãã¯å価ã¯3åã®ï¼ããããåçãé£åãã¦åå以ä¸ãããã«ãªã£ãã
Â
Â
Â
表示åæ°ï¼ã¯ãªãã¯æ°ã«ã¯ããã¾ã§å¤åãªãã®ã«ã
å¹´ã ããã¼ã®ï¼ã¯ãªãã¯å価ãæ¥éä¸ã
Â
ãã¾ãã«ãä¸ããããã¦ãã®ã§
ãªããããã«ãã£ã§ãé£ãã£ã¦ãã®ãã
ä¸å ·åã§ãããããããªããã¨æã£ã¦
æ å½è ã«åãåããã¦ã¿ãã¨ããã
ç¹ã«ããããããã§ããªããã
æ å½è æ°ããã¢ãã£æ¥çå ¨ä½ã§ãããªãããã§
åºå主ãæ¸å°ï¼äºç®ãåæ¸ããã¦ããããã§ãã
ã¢ããªãSNSã«åçãæµãã¨ãã»ã»ã¨ã®ãã¨ã
Â
ã»ãã¨ããªãï¼
Â
i-mobileã®åºåã¯2008å¹´é ã
åµæ¥ã¾ããªããããããããç»é²ããã
Â
å½æã¯ä»ã¢ãã£ãµã¤ãã«ç»é²ãã¦ãä¸å®å®ã§ãããµã¤ããæ½°ããã
å¤ãªåºåã°ããã§ã¦ãã®ã§éæ¹ã«æ®ãã¦ããã¨ããã
i-mobileã«è¡ãã¤ãã¦ã社é·ã®ç°ä¸ããã«ãç´æ¥ãã£ãããã¦ã
å½æã¯ã¢ãã£ãµã¤ãã®ä¸ã§ã群ãæãã¦å®å®ãã¦ãã¦
ããããæ°å¹´ã¯å®å®ãã¦ãããã ãã©ãã
2016å¹´ã«ä¸å ´ããä»è¿ããå°ããã¤å価ãä¸åã
ãã®ãããããå¤åãã¯ãããæ°ããããã
Â
æ²ç¤ºæ¿ãµã¼ãã¹ç³»ã¯ãpvã¯ãã®ãããããããå¹æããããªãã«ããã®ã«
google adsenseã¯æããããã
ã»ã¨ãã©ã®ã¢ããããã¯ã¼ã¯ã§ã¯æ¬é ãããã®ã«ã
å¯ä¸ãi-mobileã¯åªéãã¦ãããã®ã§ãããªãéå®ãã¦ãã
Â
ãããªi-mobileãä¸å ´å¾(2016-)ãã¾ã¨ããªä¼ç¤¾ã«ãªã£ã¦ãã¾ã£ãã®ã§ã
æ²ç¤ºæ¿ç³»ãµã¤ãããã¯æãå¼ãå§ããã®ããªã¼ã¨äºæ³ãã
 ä½æçã«ããå®éã®CPCãåççã«ãä¸å ´å¾ãããããè½ã¡ããããã
ãã ã®æ¥ççãªæµããªã®ãããããªããã©ããã©ãªãã ãï¼
Â
ã¨ã«ãããããã¾ã§åçãä¸ãã£ã¦ãã¾ãã¨ã
ãµã¼ã代ã¯æããªãããã¿ããªãããå°ã£ã¦ããããªãããªãã
ã¾ã¨ãçéãã¬ã³ã¿ã«æ²ç¤ºæ¿ã¨ãã¨ãã
åæ§ãµã¼ãã¹ãã£ã¦ã人ãã¡ãã¿ããªçµ¶å¯¾å°ã£ã¨ããããã
Â
googleã¢ãã»ã³ã¹å°å ¥ã§ããªã
ã»ã¨ãã©ã®æ²ç¤ºæ¿ãµã¤ãã¯i-mobileå°å ¥ãã¦ããã
çãé ¼ãåã£ã¦ããã ãã©ãã ã¢ã¤ã¢ãã¤ã«ãã
Â
 ã¢ã¤ã¢ãã¤ã«é£æ°ããããããããåºã¦ããäºæã
ãã¦ãã¦ã©ãããããããã
Â
ãããããèªåãã¡ã§ã¢ããããã¯ã¼ã¯ã¿ãããªã®ä½ããªãããé ãã
ã¢ããããã¯ã¼ã¯ç«ã¡ä¸ãã«èå³ãã人ã¨ããããä¸ç·ã«ã©ã¼ãã
Â
ã¢ã¤ã¢ãã¤ã«ã®ä»£ããã«ãªãããããªåºåãã£ããæãã¦ã»ããã
å°ã£ããªã¼
é çªãå¤ã«ãªã£ãã«ã©ã ãç¹å®ã®ãã¼é ã«æ¯ããªããã¦ãããªãããSQLï¼
ALTER TABLE `subject` CHANGE num num int(11) NOT NULL;
alter table subject drop primary key;
SET @i := 0; UPDATE subject SET num = (@i := @i +1) ORDER BY created;
ALTER TABLE subject CHANGE num num int auto_increment, ADD PRIMARY KEY(num);
ALTER TABLE subject AUTO_INCREMENT = @i;
å®è¡ã¯ä¸ç¬