minte9

SoftwareDevelopment / MYSQL

Keyword example

In both table page_id (key) must be same type.

 
CREATE TABLE `keyword` (
  `page_id` int(11) unsigned NOT NULL,
  `keyword` varchar(100) NOT NULL,
  `total` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`page_id`, `keyword`)
) 

CREATE TABLE `keyword_log` (
  `page_id` int(11) unsigned NOT NULL,
  `keyword` varchar(100) NOT NULL,
  `ip` varchar(15) NOT NULL,
  UNIQUE KEY `page_id` (`page_id`,`keyword`)
)

More simple than using ON keyword.page_id = keyword_log.page_id

 
SELECT *  FROM keyword 
  INNER JOIN keyword_log 
    USING (page_id)