add comment in sql

18.01.2008, 13:14 You can add comment to your mysql tables, it can help a lot while developping a big application

mysql comment

Citation

CREATE TABLE `User` (
`iduser` INT NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the user',
`name` VARCHAR( 100 ) NOT NULL COMMENT 'name of the user',
`idgroup` INT NOT NULL COMMENT 'unique identifier for the group of the user',
UNIQUE (
`iduser`
)
) ENGINE = MYISAM ;

in edit mode

Citation

ALTER TABLE `User` CHANGE `idgroup` `idgroup` INT( 11 ) NOT NULL COMMENT 'unique identifier with the group of the user'

mumuri forum.ashots.org

mumuri

Messages : 13 307