Home  >  Article  >  Database  >  excel表内的时间导入到mysql datetime类型的数据是0

excel表内的时间导入到mysql datetime类型的数据是0

WBOY
WBOYOriginal
2016-06-06 09:43:201942browse

mysqlexcel表导入datetime数据

excel表内的时间导入到mysql datetime类型的数据是0000-00-00 00:00:00,该怎么处理才好
工具是navicat for mysql

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