Difference between revisions of "Category:DB Table"
From MythTV Official Wiki
(merge with Database Schema) |
|||
| Line 1: | Line 1: | ||
| − | This category | + | This category contains all database tables currently used to store information in MythTV. |
| + | |||
| + | Use the following SQL to list all of the tables in the mythconverg [[database]]: | ||
| + | SHOW tables; | ||
| + | |||
| + | To list the structure of an individual table: | ||
| + | DESCRIBE ''name_of_table''; | ||
| + | |||
| + | To generate the SQL necessary to recreate a table: | ||
| + | SHOW CREATE TABLE ''name_of_table''; | ||
| + | |||
| + | Note: The schema is also documented in the doxygen [http://www.cuymedia.net/mythtv-trunk/group__db__schema.html developer documentation]. | ||
[[Category:Developer Documentation]] | [[Category:Developer Documentation]] | ||
| + | [[Category:MySQL]] | ||
Revision as of 17:18, 25 August 2010
This category contains all database tables currently used to store information in MythTV.
Use the following SQL to list all of the tables in the mythconverg database:
SHOW tables;
To list the structure of an individual table:
DESCRIBE name_of_table;
To generate the SQL necessary to recreate a table:
SHOW CREATE TABLE name_of_table;
Note: The schema is also documented in the doxygen developer documentation.
Subcategories
This category has the following 9 subcategories, out of 9 total.
M
U
Pages in category "DB Table"
The following 67 pages are in this category, out of 67 total.
