> suppose I have added one field time_stamp of type
> timestamp in any existing table. it will show the
> current timestamp of all records. If i update any
> record after sometime It will also update the
> timestamp of updated record with current timestamp.
>
> but for insertion of any record...w
jenny
>suppose I have added one field time_stamp of type
>timestamp in any existing table. it will show the
>current timestamp of all records. If i update any
>record after sometime It will also update the
>timestamp of updated record with current timestamp.
>
>but for insertion of any recor
Hi Jenny,
I believe that the timestamp field will automatically be set to NOW()
when you INSERT a record... In other words, you can disregard the
timestamp field in the INSERT query
Peter Normann
-Original Message-
From: Jenny Christy [mailto:[EMAIL PROTECTED]]
Sent: 30. juli 2002