Difference between revisions of "Semantic MediaWiki/data/smw inst2"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(Created page with "==About== * '''Version''': 1.7 ==SQL== <mysql>CREATE TABLE `smw_inst2` ( `s_id` int(8) unsigned NOT NULL, `o_id` int(8) unsigned DEFAULT NULL, KEY `s_id` (`s_id`), KEY...")
 
(tentative example SQL)
 
(One intermediate revision by the same user not shown)
Line 8: Line 8:
 
   KEY `o_id` (`o_id`)
 
   KEY `o_id` (`o_id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>
 
) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>
 +
==Examples==
 +
This is ''probably'' correct, based on field names and convention found in other tables, but still not sure what it means:
 +
<mysql>
 +
SELECT s_id, o_id
 +
  , CAST(s.smw_title AS char) AS s_title
 +
  , CAST(o.smw_title AS char) AS o_title
 +
  FROM
 +
    (smw_inst2 AS i
 +
    LEFT JOIN smw_ids AS s ON i.s_id=s.smw_id)
 +
    LEFT JOIN smw_ids AS o ON i.o_id=o.smw_id;
 +
</mysql>

Latest revision as of 16:08, 17 December 2012

About

  • Version: 1.7

SQL

<mysql>CREATE TABLE `smw_inst2` (

 `s_id` int(8) unsigned NOT NULL,
 `o_id` int(8) unsigned DEFAULT NULL,
 KEY `s_id` (`s_id`),
 KEY `o_id` (`o_id`)

) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>

Examples

This is probably correct, based on field names and convention found in other tables, but still not sure what it means: <mysql> SELECT s_id, o_id

 , CAST(s.smw_title AS char) AS s_title
 , CAST(o.smw_title AS char) AS o_title
 FROM
   (smw_inst2 AS i
   LEFT JOIN smw_ids AS s ON i.s_id=s.smw_id)
   LEFT JOIN smw_ids AS o ON i.o_id=o.smw_id;

</mysql>