I just tried to do this on my MySQL server (version 3.23.51-max-log). It
works fine.

Mikhail.


----- Original Message -----
From: "Anil Garg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 4:59 PM
Subject: Lost Connection to mysql server during query


> Hi,
> Here is a strange problem!!
>
> I created a table by the following qurey:
> CREATE TABLE 1_polls (
>   id int(11) unsigned NOT NULL auto_increment,
>   question varchar(128) NOT NULL default '',
>   active tinyint(1) unsigned NOT NULL default '1',
>   sortorder int(11) NOT NULL default '0',
>   module_id int(11) NOT NULL default '0',
>   last_access timestamp(14) NOT NULL,
>   PRIMARY KEY  (id)
> ) TYPE=MyISAM;
>
> Now when i try to insert by using the following query:
>
> INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,20011223105127);
>
> It gives  the error:
> Error 2013 at line 235: Lost connection to MySQL server during query
>
> If i decrease the lenght of time stamp in the INSERT query
>
> INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122);
>
>  it works fine.
>
> Can anyone help me by telling wots going wrong here!!
>
> thanx
> anil
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to