Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL存档 #9

Open
yihong0618 opened this issue Jul 27, 2019 · 1 comment
Open

MySQL存档 #9

yihong0618 opened this issue Jul 27, 2019 · 1 comment
Labels
技术文章 技术文章

Comments

@yihong0618
Copy link
Owner

  1. 更改字段类型
ALTER  TABLE 表名 MODIFY COLUMN 字段名 新数据类型 新类型长度  新默认值  新注释;
  1. 修改字段名
ALTER  TABLE 表名 CHANGE 旧字段名 新字段名 新数据类型;
  1. 添加字段
ALTER TABLE 表名 ADD 字段 类型 其他;
@yihong0618
Copy link
Owner Author

看到了一张图，记录一下
image
@yihong0618 yihong0618 added the 技术文章 技术文章 label Oct 2, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
技术文章 技术文章
1 participant
@yihong0618