Create database schema document: Difference between revisions

Jump to navigation Jump to search
No edit summary
Line 3: Line 3:


== Table document ==
== Table document ==
Sample result of mysql query<ref>[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html MySQL :: MySQL 8.0 Reference Manual :: 13.7.6.5 SHOW COLUMNS Syntax]</ref>: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}}
Sample result of mysql query using {{kbd | key=EXPLAIN}} syntax<ref>[https://dev.mysql.com/doc/refman/8.0/en/explain.html MySQL :: MySQL 8.0 Reference Manual :: 13.8.2 EXPLAIN Syntax]</ref>: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}}
<pre>
<pre>
Field | Type | Null | Key | Default | Extra
Field | Type | Null | Key | Default | Extra
</pre>
</pre>
sample result of mysql query: {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}}  
Sample result of mysql query using {{kbd | key=SHOW}} syntax<ref>[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html MySQL :: MySQL 8.0 Reference Manual :: 13.7.6.5 SHOW COLUMNS Syntax]</ref>: {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}}  
<pre>
<pre>
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment

Navigation menu