add comment in sql

Inscrit en : Apr 2002 Messages : 11073 dernière visite : 20.08.06

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

mysql comment

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

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

---8<-----------------------8<---
flooder ou ne pas flooder