List:General Discussion« Previous MessageNext Message »
From:Janek Bogucki Date:May 19 2009 9:25am
Subject:Re: load data into temporary table
View as plain text  
Hi,

mysql> create temporary table t(i int);

mysql> \! echo 1 > /tmp/data.txt

mysql> load data infile '/tmp/data.txt' into table t;
Query OK, 1 row affected (0.00 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0

mysql> select * from t;
+------+
| i    |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

Best Regards,
-Janek, CMDEV 5.0.
StudyLink. Helping People Realise Their Potential.
http://studylink.com


On Tue, 2009-05-19 at 02:57 +0100, Alex K wrote:
> Hello,
> 
> Would anyone know how to load data infile into a temporary table?
> 
> Thank you,
> 
> Alex
> 

Thread
load data into temporary tableAlex K19 May
  • Re: load data into temporary tableJanek Bogucki19 May
    • Re: load data into temporary tableAlex K19 May
      • RE: load data into temporary tableGavin Towey19 May