How to add fields and comments to a table in sql

How to add fields and comments to a table in sql

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 table name. Field name is 'remark name';

eg:

comment on column sys_cwzd.SCCLLJ is 'Upload material path';

Content extension:

Add a new field:

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

1. Set the encoding when creating the database

create database test character set utf8;

2. Set the encoding when creating a table

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

3. Modify the database encoding

alter database test character set utf8;

4. Modify the default encoding of the table

alter table test character set utf8;
You may also be interested in:
  • Several ways to add timestamps in MySQL tables
  • How to add indexes to MySQL
  • MYSQL implements sample code to prevent duplicate addition when adding shopping cart
  • How to create a stored procedure in MySQL and add records in a loop
  • Summary of MySQL's commonly used SQL statements for creating tables, adding fields, modifying fields, and adding indexes

<<:  Detailed explanation of Vue's methods and properties

>>:  CentOS 6 uses Docker to deploy Zookeeper operation example

Recommend

js precise calculation

var numA = 0.1; var numB = 0.2; alert( numA + num...

MySQL 8.0.15 version installation tutorial connect to Navicat.list

The pitfalls 1. Many tutorials on the Internet wr...

Introduction to common MySQL storage engines and parameter setting and tuning

MyISAM, a commonly used storage engine in MySQL c...

Introduction to Nginx regular expression related parameters and rules

Preface Recently, I have been helping clients con...

Dockerfile text file usage example analysis

Dockerfile is a text file used to build an image....

td content automatically wraps table table td after setting the width too much text automatically wraps

Set the table's style="table-layout:fixed...

Correct use of MySQL partition tables

Overview of MySQL Partitioned Tables We often enc...

Detailed explanation of how to install MySQL on Alibaba Cloud

As a lightweight open source database, MySQL is w...

Using VMware IOInsight to perform refined virtual machine storage performance monitoring

illustrate: VMware IOInsight is a tool that helps...

Summary of basic operations for MySQL beginners

Library Operations Query 1.SHOW DATABASE; ----Que...

MySQL 5.7.18 free installation version configuration tutorial

MySQL 5.7.18 free installation version installati...

W3C Tutorial (3): W3C HTML Activities

HTML is a hybrid language used for publishing on ...

Best tools for taking screenshots and editing them in Linux

When I switched my primary operating system from ...

Implementation of Docker cross-host network (overlay)

1. Docker cross-host communication Docker cross-h...

Some points on using standard HTML codes in web page creation

<br />The most common mistake made by many w...