\T QUESTION

2002-06-05 Thread Joshua Richards
Hello, IS it possible to export a query from mysql in a specific format. I created a query- SELECT id,title,class,grade FROM semester1; \T semester1 but it exported the query in a table form. Can anyone tell me if you can export the query in another formatTab delimited,cvs etc. Any hel

\T Question!!!

2002-06-05 Thread Joshua Richards
Hello, IS it possible to export a query from mysql in a specific format. I created a query- SELECT id,title,class,grade FROM semester1; \T semester1 but it exported the query in a table form. Can anyone tell me if you can export the query in another formatTab delimited,cvs etc. Any hel

Load data command?

2002-05-15 Thread Joshua Richards
Hi, Could anyone please tell me how I could load a text file into a specific column in mysql. I tried LOAD DATA INFILE but didn't work Thanks, J.Richards - Before posting, please check: http://www.mysql.com/manual.php