Home >Database >Mysql Tutorial >mysql给表添加字段的命令_MySQL
mysql给表添加字段的命令_MySQL
- WBOYOriginal
- 2016-06-01 13:17:55849browse
bitsCN.com
给表添加字段的命令：
alter table tableName add newColumn varchar(8) comment '新添加的字段'
在这句语句中需要注意的是，comment为注释，就像在java中//作用是一样的。
comment后需要加单引号将注释引起来。
bitsCN.comStatement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql的事务运作_MySQLNext article：phpMyAdmin 4.1.12 发布 MySQL 管理工具_MySQL