RE: [PHP] Batch job in UNIX.

On 05-Jul-01 Johan Vikerskog (ECS) wrote: > But i want dont want to type in the password. I want to have the password in > the command file. No, you don't. Put your user name & password in ~/.my.cnf (as explained in the fine manual). -- Don Read [EMAIL

RE: [PHP] Batch job in UNIX.

On 05-Jul-01 Johan Vikerskog (ECS) wrote: > If i want to add something into a table with just the mysql command. > Is this possible. > > Like > ./mysql -p -u root test "insert into..." mysql -e "cmd" mysql -B "cmd" mysql < somescript.sql cat many*.sql | mysql -- also look at -- mysql --help

RE: [PHP] Batch job in UNIX.

>But i want dont want to type in the password. I want to have >the password in the command file. >>echo "insert into..." | ./mysql -p -u root test >>or >>cat filename | ... Perfectly right. And a "mysql --help" would have told you that you can call it (combined with the above) like this:

Re: [PHP] Batch job in UNIX.

Johan Vikerskog (ECS) wrote: > But i want dont want to type in the password. I want to have the > password in the command file. "--password=whatever_it_is" instead of "-p" ? If that doesn't help, try ./mysql --help regards Wagner -- Madness takes its toll. Please have exact change. -- PHP G

RE: [PHP] Batch job in UNIX.

But i want dont want to type in the password. I want to have the password in the command file. //Johan -Original Message- From: Alexander Wagner [mailto:[EMAIL PROTECTED]] Sent: den 5 juli 2001 12:57 To: Johan Vikerskog (ECS); [EMAIL PROTECTED] Subject: Re: [PHP] Batch job in UNIX

Re: [PHP] Batch job in UNIX.

Johan Vikerskog (ECS) wrote: > If i want to add something into a table with just the mysql command. > Is this possible. > > Like > ./mysql -p -u root test "insert into..." > > Something like this.Is that possible and how in that case. echo "insert into..." | ./mysql -p -u root test or cat filenam