Tango.info sql query list: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 17: | Line 17: | ||
from | from | ||
dbwiki.mul_page : page_id, page_title | dbwiki.mul_page : page_id, page_title | ||
fill | fill | ||
dbtango.tango_wiki_pages : page_id, time_start, time_end | dbtango.tango_wiki_pages : page_id, time_start, time_end | ||
S O L U T I O N | S O L U T I O N | ||
TRUNCATE TABLE `tango_wiki_pages` ; | TRUNCATE TABLE `tango_wiki_pages` ; | ||
INSERT INTO `tango_wiki_pages` SET page_id = 1# Affected rows: 1 | INSERT INTO `tango_wiki_pages` SET page_id = 1# Affected rows: 1 |
Revision as of 2007-11-13T18:13:39
SELECT * FROM tango_persons_x_pascale , tango_persons WHERE tango_persons.person_code = tango_persons_x_pascale.code SELECT * FROM tango_persons_x_pascale LEFT JOIN tango_persons ON tango_persons.person_code = tango_persons_x_pascale.code
T A S K from dbwiki.mul_page : page_id, page_title fill dbtango.tango_wiki_pages : page_id, time_start, time_end S O L U T I O N TRUNCATE TABLE `tango_wiki_pages` ; INSERT INTO `tango_wiki_pages` SET page_id = 1# Affected rows: 1