ExpertRefresh

Query / Using syntax  

Related Pages

Order by rand
Concat fields
Select search
Regexp
If null
Union
Using syntax
Ucfirst


0.0% 100%
 
 
0 pages 19 questions
1) Which is correct








SELECT * FROM keyword JOIN keyword_log USING (page_id)

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`) )


References



n/a