Re: How to spool a file to your server from mysql

2002-01-23 Thread Roger Baklund
* Cindy Yu, January 23, 2002 7:18 PM > When I use this on Sun saloris, it does work. ok... I guess you mean solaris, and maybe you even mean it does NOT work? > mysql> use mysql > Database changed > mysql> tee /usr/local/var/ub_store > it shows syntax error with tee. What do you mean "it shows

Re: RE: How to spool a file to your server from mysql

2002-01-23 Thread Cindy Yu
Hi Roger, When I use this on Sun saloris, it does work. mysql> use mysql Database changed mysql> tee /usr/local/var/ub_store it shows syntax error with tee. Can you tell me how to do it on Sun saloris? Thanks! Cindy >>> "Roger Baklund" <[EMAIL PROTECTED]> 01/11 11:25 AM >>> * Cindy Yu > I

RE: How to spool a file to your server from mysql

2002-01-11 Thread Roger Baklund
* Cindy Yu > I am new to mysql. I know, in Oracle, when you spool file, then > spool off, this will create a file on your server. What is the > equivalent command for Mysql. > > For example: > sqlplus> Spool C:\temp\table_names > sqlplus> select table_name from user_tables; > sqlplus> spool off;

Re: How to spool a file to your server from mysql

2002-01-11 Thread Ryan Fox
Check out select into outfile. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL ECT Ryan - Original Message - From: "Cindy Yu" <[EMAIL PROTECTED]> I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will create a file on your ser