Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql给表添加字段的命令_MySQL

mysql给表添加字段的命令_MySQL

WBOY
Release： 2016-06-01 13:17:55
Original
830 people have browsed it

bitsCN.com

给表添加字段的命令：

alter table tableName add newColumn varchar(8) comment '新添加的字段'
Copy after login

在这句语句中需要注意的是，comment为注释，就像在java中//作用是一样的。

comment后需要加单引号将注释引起来。

bitsCN.com
Related labels：
comment mysql
source：php.cn
Previous article：mysql的事务运作_MySQL Next article：phpMyAdmin 4.1.12 发布 MySQL 管理工具_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
One-to-many mapping Hibernate I'm trying to keep 6 comments in the Comment table of the database using a foreign key to ...
From 2024-04-01 19:57:24
0
2
372
React Native keyboard pushes everything up and I have no control When the keyboard is open, I only want the comment input to move up, but all content moves...
From 2024-03-30 21:40:43
0
1
348
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template