Menu
▾
▴
Re: [SQLObject] Joins Not Working
|
From: Markos K. <mk...@gm...> - 2011-01-30 23:33:48
|
<html> <head> <title>SHOW FULL COLUMNS FROM title; </title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body><h1>SHOW FULL COLUMNS FROM title; </h1> <table border=1 cellspacing=1 cellpadding=0><tr> <th>Field</th><th>Type</th><th>Collation</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th><th>Privileges</th><th>Comment</th></tr> <tr> <td>id</td><td>int(11)</td><td></td><td>NO</td><td>PRI</td><td></td><td>auto_increment</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>isbn</td><td>varchar(10)</td><td>utf8_unicode_ci</td><td>NO</td><td>MUL</td><td> </td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>booktitle</td><td>text</td><td>utf8_unicode_ci</td><td>YES</td><td>MUL</td><td></td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>publisher</td><td>varchar(50)</td><td>utf8_unicode_ci</td><td>NO</td><td>(null)</td><td> </td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>release_date</td><td>varchar(255)</td><td>utf8_unicode_ci</td><td>YES</td><td>(null)</td><td></td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>tag</td><td>text</td><td>utf8_unicode_ci</td><td>YES</td><td>(null)</td><td></td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>kind_id</td><td>int(11)</td><td></td><td>YES</td><td>MUL</td><td></td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>edition</td><td>int(11)</td><td></td><td>YES</td><td>(null)</td><td></td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> <tr> <td>type</td><td>varchar(25)</td><td>utf8_unicode_ci</td><td>YES</td><td>(null)</td><td></td><td>(null)</td><td>select,insert,update,references</td><td>(null)</td></tr> </table> </body></html> |
