How to load data into non-empty tables

2002-01-28 Thread Cindy Yu
Hello, On Sun Saloris box, can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates! Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> Just for the record, found the glitch: somehow, somebody on the way decided to change LF's

How to load data into non-empty tables

2002-01-28 Thread Cindy Yu
Hello, Can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates! Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> Just for the record, found the glitch: somehow, somebody on the way decided to change LF's into CRLF's (I remote

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

How to spool a file to your server from mysql

2002-01-11 Thread Cindy Yu
Hello, 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; This will crea

Re: RE: RE: RE: Mysql connection problem

2002-01-08 Thread Cindy Yu
Hi Gary, Finally I can access the server. You are my hero. I am new to mysql. It takes me a month to try it. Thank you very very much! Cindy >>> <[EMAIL PROTECTED]> 01/08 11:14 AM >>> from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:

Re: RE: RE: Mysql connection problem

2002-01-08 Thread Cindy Yu
erver with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAI

Re: RE: Mysql connection problem

2002-01-07 Thread Cindy Yu
bles. See on line manual and don't know password. Or ./mysql --help Simon -----Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a questi

Mysql connection problem

2002-01-07 Thread Cindy Yu
Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can