Tango.info sql query list: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 8: Line 8:
FROM tango_persons_x_pascale
FROM tango_persons_x_pascale
LEFT JOIN tango_persons ON tango_persons.person_code = tango_persons_x_pascale.code
LEFT JOIN tango_persons ON tango_persons.person_code = tango_persons_x_pascale.code




Line 28: Line 26:
===solution===
===solution===
  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

Revision as of 2007-11-13T18:17:15

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

wiki article datetime

task

from 

dbwiki.mul_page : page_id, page_title

fill 

dbtango.tango_wiki_pages : page_id, time_start, time_end

where page_title can be like

  • 2007-10-12--14_Festival_Karlsruhe
  • 2007-05-30--06-03_Festival_Sydney
  • 2007-12-07--2008-01-06_Festival_Roma

solution

TRUNCATE TABLE `tango_wiki_pages` ;
INSERT INTO `tango_wiki_pages` SET page_id = 1
Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_sql_query_list&oldid=10346"