这个本身属于MySQL的基本语法,我这里给出一个例子而已。
mysql> -- 测试数据库在指定位置增加字段 mysql> drop table if exists t; Query OK, 0 rows affected (0.06 sec) mysql> create table t(age int,address varchar(50)); Query OK, 0 rows affected (0.06 sec) mysql> desc t; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | age | int(11) | YES | | NULL | | | address | varchar(50) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.02 sec) mysql> alter table t add column name varchar(20) after age; Query OK, 0 rows affected (0.16 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> desc t; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | age | int(11) | YES | | NULL | | | name | varchar(20) | YES | | NULL | | | address | varchar(50) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> alter table t add column id int FIRST; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> desc t; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | age | int(11) | YES | | NULL | | | name | varchar(20) | YES | | NULL | | | address | varchar(50) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql>
基本语法:
ALTER TABLE 表名 ADD 字段名 字段类型 [AFTER 字段名]|[FIRST];
内容版权声明:除非注明,否则皆为本站原创文章。
转载注明出处:https://sulao.cn/post/336
相关推荐
- flask连接mysql使用peewee连接池
- ubuntu在线安装mysql8无法使用账户密码登陆的问题
- ubuntu22.04编译安装mysql8
- flask使用celery异步定时任务备份mysql数据库
- mysql8登录报错Host '127.0.0.1' is not allowed to connect...
- python使用peewee(ORM)操作mysql数据库
- MySQL CPU占用过高的排查方法
- docker-compose编排lnmp(nginx+php+mysql)环境
- docker和docker-compose分别部署mysql5.7
- centos7编译安装mysql8
评论列表