Re: timestamp(14) fails to change on load data infile

[Clownfish Internet Services - www.clown-fish.com]

Thank you very much -

This works fine now !

Clownfish

----- Original Message -----
From: "Pat Sherrill" <[EMAIL PROTECTED]>
To: "Clownfish Internet Services - www.clown-fish.com"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 6:00 PM
Subject: Re: timestamp(14) fails to change on load data infile


>
> When using a TIMESTAMP column with LOAD DATA INFILE, the TIMESTAMP must be
> either set to NULL or an appropriate date within the import file or
> specifically left out of the field list in the LOAD DATA INFILE statement
as
> follows:
>
>   LOAD DATA INFILE  'example.csv' replace into table example FIELDS
> TERMINATED BY ',' (id,name);
>
> otherwise TIMESTAMP will be set to the appropriate zero value
> ('00000000000000').
>
> I hope this helps...
>
> Pat...
> [EMAIL PROTECTED]
>
> BTW  I would recommend against using 'timestamp' as a column name since it
> is a reserved word.
>
> ----- Original Message -----
> From: "Clownfish Internet Services - www.clown-fish.com"
> <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, February 04, 2001 11:20 AM
> Subject: timestamp(14) fails to change on load data infile
>
>
> > I am experiencing problems trying to dynamically link tables in
Microsoft
> > Access 2000 using ODBC and MYSQL.
> >
> > MYSQL  Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
> > ODBC  myodbc-2.50.36-win95
> > MS Access2000 with MDAC 2.1
> >
> > The error messages I am getting are "this record has been changed by
> another
> > user since you started editing it"
> > I believe it is due to duplicate timestamp(14) values.
> >
> > For Example:
> >
> > I have a simple data base created using the following statement:
> >
> > create table example (id int(11) NOT NULL AUTO_INCREMENT, name
> > varchar(10),timestamp timestamp(14),PRIMARY KEY(id));
> >
> > ***no problem***
> >
> > mysql> describe example;
> > +-----------+---------------+------+-----+---------+----------------+
> > | Field     | Type          | Null | Key | Default | Extra          |
> > +-----------+---------------+------+-----+---------+----------------+
> > | id        | int(11)       |      | PRI | NULL    | auto_increment |
> > | name      | varchar(10)   | YES  |     | NULL    |                |
> > | timestamp | timestamp(14) | YES  |     | NULL    |                |
> > +-----------+---------------+------+-----+---------+----------------+
> > 3 rows in set (0.00 sec)
> >
> > ***problem***
> >
> > when I import external data in the following format (example.csv)
> >
> >
> > 1,aaaaaaaaaaaaaaaaa
> > 2,bbbbbbbbbbbbbbbbb
> > 3,ccccccccccccccccc
> >
> >
> > using the following statement:
> >
> > load data local infile  '/home/fred/example.csv' replace into table
> example
> > FIELDS TERMINATED BY ',';
> >
> > mysql> select * from example;
> > +----+------------+----------------+
> > | id | name       | timestamp      |
> > +----+------------+----------------+
> > |  1 | aaaaaaaaaa | 00000000000000 |
> > |  2 | bbbbbbbbbb | 00000000000000 |
> > |  3 | cccccccccc | 00000000000000 |
> > +----+------------+----------------+
> > 3 rows in set (0.00 sec)
> >
> > The timestamp has not been changed upon import and hence is duplicated
> > throughout.
> >
> > ***Question***
> >
> > Is there any way to import from an external source and create a modified
> > (unique) timestamp upon import ?
> > I have tried defining the timestamp(14) column with "default 'now' ",
> > suggested by somone else with a
> > similar problem but it doesn't seem to work.
> >
> > Please Help !
> >
> > Clownfish
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
>


---------------------------------------------------------------------
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