Tango.info sql query list

From tango.info wiki
Revision as of 2007-11-13T18:13:27 by Tobiasco (talk | contribs)
Jump to navigation Jump to search
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