dongshi9489 2017-04-06 09:12
浏览 76
已采纳

在mysql中导入数据期间自动插入列

  • I have five column in .csv file and i have to import it in MySQL table.
  • But i also required date on which i import file in database.

So i mean six column in table with today date.

  • I have tried with use time stamp as datatype and CURRENT_TIMESTAMP in default.

But it occurs query:- Invalid column count in CSV input on line 1.

Please guide me.

Screen Shot:- enter image description here

Csv File:- enter image description here

  • 写回答

2条回答 默认 最新

  • dsizd368332 2017-04-06 09:29
    关注

    This means the number of column in your csv and table is not same. If you want to set default value of any column you have to keep this value empty but you have to mention this column. For example: if you want to insert 3 columns having a default value for 1 column named 'created' your csv file should look like this:

    enter image description here

    Please remove first row which describes your table structure. I mean do not use the following instead of the above: enter image description here

    And finally run the following sql if current timestamp is not set:

    UPDATE `table` SET edate = current_timestamp;
    

    Here put your table name it 'table' phrase.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)