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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org