时间戳

首页 > 解决方案 > PhpStorm Dumb to file (CSV) Import back gives 1:5: conversion failed: "" to datetime

phpstorm - PhpStorm Dumb to file (CSV) Import back gives 1:5: conversion failed: "" to datetime

问题描述

I exported my table to CSV and now need to import back and my column created and modified has a type timestamp = CURRENT_TIMESTAMP and is failing.

PhpStorm export as datetime e.g: 2019-07-29 15:51:12 import fails obviously as the type is different!

PHPStorm import has preview before import: enter image description here

enter image description here enter image description here Is there a way to export/import to CSV as timestamp ?

标签： phpstormexport-to-csvdatagripimport-csv

解决方案

推荐阅读