Shulou(Shulou.com)06/01 Report--

Comments in Oracle

For example, comment on column table name is' xxxx';-- Table comments

Comment on column table name. Field name is' xxxxx'-- Field comment

Comments in mysql

-- annotate when creating a table

CREATE TABLE zy.student_info (

NAME VARCHAR (20) NOT NULL COMMENT 'student name'

Kecheng VARCHAR (20) NOT NULL

Fenshu INT (10)

) ENGINE=INNODB DEFAULT CHARSET=utf8

Modify the comments of the table

Alter table test1 comment 'comments on modified tables'

View field comment

Show full columns from table name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.