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

Labels

Owner

yihong0618 commented Jul 27, 2019

更改字段类型

ALTER  TABLE 表名 MODIFY COLUMN 字段名 新数据类型 新类型长度  新默认值  新注释;

修改字段名

ALTER  TABLE 表名 CHANGE 旧字段名 新字段名 新数据类型;

添加字段

ALTER TABLE 表名 ADD 字段 类型 其他;

Owner Author

yihong0618 commented Aug 5, 2019

看到了一张图，记录一下

yihong0618 added the 技术文章 label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment