timestamp data type in MySQL

Hi,
     using PHPMyAdmin console,  when i insert a row into a table I'm expecting the LastUpdate column to display the time/date of the insert, this is not happening. Below is the CREATE TABLE query I used and an output of the table..
query i am using to update is typically
INSERT INTO coords VALUES ('','12345678','')

also tried
INSERT INTO coords VALUES ('','12345678','NOW()')
INSERT INTO coords VALUES ('','12345678','CURRENT_TIMESTAMP')

ps on update CURRENT_TIMESTAMP was an attribute i added to the schema, it wasn't in the existing CREATE DATABASE statement...
thanks
--
-- Table structure for table `coords`
--

CREATE TABLE IF NOT EXISTS `coords` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `latlong` varchar(255) NOT NULL,
  `LastUpdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `coords`
--

INSERT INTO `coords` (`id`, `latlong`, `LastUpdate`) VALUES
(1, '53.290797619999005 -6.27508931844', '0000-00-00 00:00:00'),
(2, '53.290797619999005 -6.27508931844', '0000-00-00 00:00:00'),
(3, '53.290797619999005 -6.27508931844', '0000-00-00 00:00:00'),
(4, '53.290797619999005 -6.27508931844', '0000-00-00 00:00:00'),
(5, '53.290797619999005 -6.27508931844', '0000-00-00 00:00:00');

Open in new window

blossomparkAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
gamebitsConnect With a Mentor Commented:
INSERT INTO coords VALUES ('','12345678',NOW())

NOW() without the quote '
0
 
blossomparkAuthor Commented:
gamebits, you truly are a wizard... excellent..working 100%%%%%%% !!!!!!!!!!!!!!
0
 
gamebitsCommented:
Glad to help, thanks for the points and grade.
0
All Courses

From novice to tech pro — start learning today.