* Osnat Rabi
> My table has 3 columns: id, name, timestamp.
>
> When I use the MySQL command line client,
> (a) insert into table values(1,'xxx') fails for
> insufficient number of values.
I don't know if this will help you, but this is valid:
insert into table set id=1, name='xxx';
-
Use one of the other column types, like datetime, instead.
- Original Message -
From: "MikeBlezien" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 11:37
Subject: timestamp column
> Hello All,
>
> I need to create a database table with a timestamp column data t
"MikeBlezien" <[EMAIL PROTECTED]> wrote:
> I need to create a database table with a timestamp column data type, but I
don't
> what it to change each time the row is updated. How can you prevent the
> timestamp column from changing each time it's updated.
Use the DATETIME field type instead and se
