[PHP] Batch job in UNIX.

2001-07-05 Thread Johan Vikerskog (ECS)
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. Johan Vikerskog Technician - CAE Tools Support Research Technology Development

Re: [PHP] Batch job in UNIX.

2001-07-05 Thread Alexander Wagner
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 filename | ...

RE: [PHP] Batch job in UNIX.

2001-07-05 Thread Johan Vikerskog (ECS)
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.

2001-07-05 Thread Alexander Wagner
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

RE: [PHP] Batch job in UNIX.

2001-07-05 Thread Gunther E. Biernat
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: echo

RE: [PHP] Batch job in UNIX.

2001-07-05 Thread Don Read
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 -- Don

RE: [PHP] Batch job in UNIX.

2001-07-05 Thread Don Read
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