Adding metadata to learning material using mysql
am developing a mysql database that contains large collection of learning materials, and i need to know how to add metadata to each materia开发者_运维知识库l using mysql is there any authoring tool that can assist in creating the metadata
anyone can help regarding this matter
thanks in advance
If you're looking for information about the tables and databases themselves, you may be looking for INFORMATION_SCHEMA http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
If you're attempting to add your own "metadata" about items in tables or databases, I would suggest creating a parallel table/database to store the information and do your own operations on it. Alternatively, change the layout of your tables to include fields for comments such that comments are in a definite position with respect to the data is concerns.
精彩评论