Home > Database > Mysql Tutorial > mysql 数据导出修改表结构后,再导入,新添加的字段插入默认值

mysql 数据导出修改表结构后,再导入,新添加的字段插入默认值

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 09:38:30
Original
906 people have browsed it

mysql数据

要实现的例子:
表A (a0,a1) 拥有数据100条

现在要将表结构修改为,A(a0,a1,a2),但是不想重新输入数据
所以,想先从旧的表中到处数据,然后导入新表,字段a2取默认值或固定值

求解决方案!!

Related labels:
source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template