Is it possible to comment the fields in a table in Mysql?
Moderator: General Moderators
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
Is it possible to comment the fields in a table in Mysql?
I am wondering is it possible in MYSQL to comment all the fields in every table as it is possible with MS ACCESS?
- J_Iceman05
- Forum Commoner
- Posts: 72
- Joined: Wed Aug 03, 2005 10:52 am
- Location: Las Vegas, NV
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
If you had worked with MS Access, you would hv known it
for ex:
there exists a table
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- n00b Saibot
- DevNet Resident
- Posts: 1452
- Joined: Fri Dec 24, 2004 2:59 am
- Location: Lucknow, UP, India
- Contact:
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.
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.