Shulou(Shulou.com)05/31 Report--

This article mainly introduces sql how to add fields in a table and add comments, the article is very detailed, has a certain reference value, interested friends must read!

1. Add fields:

alter table table name ADD field name type;

eg:

alter table sys_cwzd ADD SCCLLJ VARCHAR2(50);

2. Add remarks:

comment on column name. Field name is 'Memo name';

eg:

comment on column sys_cwzd.SCCLLJ is 'Upload Material Path';

Content expansion:

Add new fields:

alter table bulletin add citycode varchar(6) not null default 0; #city code

1. Set encoding when creating database

create database test character set utf8;

2. Set encoding when creating tables

create table test(id int primary key)DEFAULT charset=utf8;

3. Modify database encoding

alter database test character set utf8;

4. Modify table default code

alter table test character set utf8; above is "sql how to add fields to a table and add comments" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

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.