Home >Database >Mysql Tutorial >mysql-Mysql中load data infile时能否为其它字段设值
mysql-Mysql中load data infile时能否为其它字段设值
- WBOYOriginal
- 2016-06-06 09:35:291301browse
mysql
比如我现在有一张表，字段有a、b、c、d四个，load data时的txt文件只包含3个字段（a、b、c）的值，在导入的同时，我能为每条记录的d字段设置一个值吗？（比如操作的用户名等）
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：mysql-oracle的sql语句怎么转换成MySQL里的sql语句呢Next article：mysql-navicat连接显示can't connect to Mysql Server