Tango.info sql query list: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
(New page: <pre> 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 O...)
 
No edit summary
Line 13: Line 13:




</pre>
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
</pre>
TRUNCATE TABLE `tango_wiki_pages` ;
INSERT INTO `tango_wiki_pages` SET page_id = 1# Affected rows: 1

Revision as of 2007-11-13T18:13:27

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
Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_sql_query_list&oldid=10342"