http://xataface.com/wiki/index.php?-table=wiki&-action=list&page_name=%3DKey&-cursor=0&-skip=0&-limit=30&-mode=list 2013-05-22T11:21:18+01:00 text/html http://xataface.com/wiki/index.php Key http://www.xataface.com/wiki/Key <table><thead><tr><th>Field</th><th>Value</th></tr></thead><tbody><tr><td valign="top">Page name</td><td valign="top">Key</td></tr><tr><td valign="top">Page id</td><td valign="top">83</td></tr><tr><td valign="top">Page title</td><td valign="top">fields.ini Directive: Key</td></tr><tr><td valign="top">Content</td><td valign="top"><p>The <strong>Key</strong> directive is used only when the table is a view and you need to explicitly define which columns are part of the primary key. For example, if we created a view on the books table to only show books in a given year as follows: &lt;code&gt; create</p> </td></tr><tr><td valign="top">Keywords</td><td valign="top">Key, Views, MySQL Views, Create View, PRI, Primary Keys</td></tr><tr><td valign="top">Language</td><td valign="top">en</td></tr></tbody></table>