Thank you but the real problem occurs when you don't know the schema of the table in advance. If data.txt has two columns columns how can I still load it in a temporary table? I'm asking this question because I'd like to add an import csv feature to a web application. I know that you can load data infile into table without specifying the schema of this table but it does not look like you can do load data infile into a temporary table.
Thank you, Alex 2009/5/19 Janek Bogucki <janek.bogu...@studylink.com>: > 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=alex.ksi...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
