Tango.info sql query list: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 15: | Line 15: | ||
</pre> | </pre> | ||
==wiki article datetime== | ==wiki article datetime== | ||
===task=== | |||
from | from | ||
dbwiki.mul_page : page_id, page_title | dbwiki.mul_page : page_id, page_title | ||
| Line 26: | Line 26: | ||
*2007-12-07--2008-01-06_Festival_Roma | *2007-12-07--2008-01-06_Festival_Roma | ||
===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# Affected rows: 1 | ||
Revision as of 2007-11-13T18:16:16
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# Affected rows: 1