Home >Backend Development >PHP Tutorial > 小弟我用phpmyadmin导入excel小弟我表里面有自增字段导不进去怎么处理
小弟我用phpmyadmin导入excel小弟我表里面有自增字段导不进去怎么处理
- WBOYOriginal
- 2016-06-13 13:15:07867browse
我用phpmyadmin导入excel我表里面有自增字段导不进去怎么办？
我把excel转换成csv导入，我想跳过自增字段插入，要怎么做呢
------解决方案--------------------
指定字段导入
load data infile 'csv文件' into table 表名(name,age);
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： 悲催的PHP新式字符串 Next article： 新手 php ajax有关问题