Home >Database >Mysql Tutorial >How to remove auto_increment from column in mysql_MySQL
How to remove auto_increment from column in mysql_MySQL
- WBOYOriginal
- 2016-06-01 13:13:03985browse
Alter table table_name DROP PRIMARY KEY,
change column_name column_name datatype(length) definition
Consider the example:
The structure of table1 in database new look like this:
Now we are going to remove auto increment from column 'No' in mysql table 'table1'. The mysql query is:
Statement：
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：关于一个用户迁移数据库前后的性能差异分析_MySQLNext article：Ubuntu 14.04 LTS 安装 LNMP Nginx/PHP5 (PHP-FPM)/MySQL_MySQL