Page 1 of 1
Is it possible to comment the fields in a table in Mysql?
Posted: Thu Oct 20, 2005 7:57 am
by raghavan20
I am wondering is it possible in MYSQL to comment all the fields in every table as it is possible with MS ACCESS?
Posted: Fri Oct 21, 2005 12:32 pm
by J_Iceman05
what do you mean by commenting all the fields in every table... not access them, or what? why would you need to comment them anyway?
Posted: Fri Oct 21, 2005 6:54 pm
by raghavan20
If you had worked with MS Access, you would hv known it
for ex:
there exists a table
Code: Select all
FieldName Comment
-----------------------------------------------------------
OrderId Unique id of every order
Date Date on which the order is made
MemberId The member who has made the order
Posted: Sat Oct 22, 2005 1:23 am
by n00b Saibot
i think there may be incompatibilities existing in the syntax of SQL. you are better off writing query and executing in MySQL (or may be convert a query from MS Access

)
EDIT: scrap above answer... i misunderstood your question.. yeah, i think its possible.
Posted: Sat Oct 22, 2005 4:52 am
by onion2k
It's not possible for MyISAM tables. There's a short space available for a comment, but it's not much. InnoDB tables may accept a comment for each column..
EDIT: After doing a little (like, 30 seconds) research it appears that InnoDB tables are even more useless for comments than MyISAM. MySQL puts table space data in the comment.. not good.