MySQL Forums
Forum List  »  MySQL for Excel

Re: Error saving time back to MYSQL
Posted by: Rod Miller
Date: June 13, 2017 12:36AM

Hi Javier

I just follow the wizard to connect to the database and import the data. I then try to edit any of the data and save it back, it doesn't have to be in the time field and it just gives me the error.

This is the database and a standard kind of row.

-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 13, 2017 at 08:31 AM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 7.1.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `fafa1424_records`
--

-- --------------------------------------------------------

--
-- Table structure for table `newrecords`
--

CREATE TABLE `newrecords` (
`id` int(11) NOT NULL,
`memberID` varchar(4) NOT NULL,
`animalID` varchar(25) DEFAULT NULL,
`nickName` varchar(50) NOT NULL,
`animal` varchar(256) NOT NULL,
`family` varchar(150) DEFAULT NULL,
`code` varchar(10) DEFAULT NULL,
`dateOfEncounter` date DEFAULT '1970-01-01',
`encounterAddress` varchar(256) DEFAULT NULL,
`postcode` varchar(256) DEFAULT NULL,
`LGA` varchar(256) DEFAULT NULL,
`encounterType` varchar(100) DEFAULT NULL,
`animalCondition` varchar(256) DEFAULT NULL,
`comment` mediumtext,
`animalSex` varchar(30) DEFAULT NULL,
`age` varchar(50) DEFAULT NULL,
`initalWeight` varchar(20) DEFAULT NULL,
`pouchCondition` varchar(256) DEFAULT NULL,
`initialAssessor` varchar(256) DEFAULT NULL,
`rehabilitatorName` varchar(256) DEFAULT NULL,
`fateOfAnimal` varchar(256) DEFAULT NULL,
`memberHolding` varchar(256) DEFAULT NULL,
`dateOfFate` date DEFAULT '1970-01-01',
`releaseLocation` varchar(256) DEFAULT NULL,
`releasePostcode` varchar(256) DEFAULT NULL,
`releaseGPS` varchar(50) DEFAULT NULL,
`chipNumber` varchar(256) DEFAULT NULL,
`rehabilitator1` varchar(256) DEFAULT NULL,
`rehabilitator2` varchar(256) DEFAULT NULL,
`rehabilitator3` varchar(256) DEFAULT NULL,
`rehabilitator4` varchar(256) DEFAULT NULL,
`date_transfer1` date DEFAULT '0000-00-00',
`date_transfer2` date DEFAULT '0000-00-00',
`date_transfer3` date DEFAULT '0000-00-00',
`date_transfer4` date DEFAULT '0000-00-00',
`timeOfCall` time DEFAULT NULL,
`callerDetails` varchar(256) DEFAULT NULL,
`contactNumber` varchar(20) DEFAULT NULL,
`incidentDetails` varchar(1024) DEFAULT NULL,
`memberContacted` varchar(256) DEFAULT NULL,
`actionTaken` varchar(256) DEFAULT NULL,
`finalised` varchar(5) DEFAULT NULL,
`recordFinalised` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `newrecords`
--

INSERT INTO `newrecords` (`id`, `memberID`, `animalID`, `nickName`, `animal`, `family`, `code`, `dateOfEncounter`, `encounterAddress`, `postcode`, `LGA`, `encounterType`, `animalCondition`, `comment`, `animalSex`, `age`, `initalWeight`, `pouchCondition`, `initialAssessor`, `rehabilitatorName`, `fateOfAnimal`, `memberHolding`, `dateOfFate`, `releaseLocation`, `releasePostcode`, `releaseGPS`, `chipNumber`, `rehabilitator1`, `rehabilitator2`, `rehabilitator3`, `rehabilitator4`, `date_transfer1`, `date_transfer2`, `date_transfer3`, `date_transfer4`, `timeOfCall`, `callerDetails`, `contactNumber`, `incidentDetails`, `memberContacted`, `actionTaken`, `finalised`, `recordFinalised`) VALUES
(721, '0335', '0335-15-0003', 'Smokey', 'Frogmouth, Tawny', 'BN', '313', '2015-09-16', 'South West Rocks Road, ', '2440 - POLA CREEK', 'Kempsey Shire Council', 'Collision - Motor Vehicle', 'Injury to body', 'Found on the road at night, possibly hit by car.16', 'Unknown', 'Unknown', 'unkown', 'N/A', '0335 - Yvonne', '0335 - Yvonne', '', '0335 - Yvonne', NULL, '', '', '', '', '', '', '', '', '1970-01-01', '1970-01-01', '1970-01-01', '1970-01-01', '05:12:12', '', '', '', '', '', '', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `newrecords`
--
ALTER TABLE `newrecords`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `animalid` (`animalID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `newrecords`
--
ALTER TABLE `newrecords`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13709;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Options: ReplyQuote


Subject
Views
Written By
Posted
164
June 05, 2017 12:35AM
Re: Error saving time back to MYSQL
89
June 13, 2017 12:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.