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: echo "insert into..." | mysql -uroot -pwhitehat test or if you just don't want to type the mysql command parameters all the time, make yourself a shell script: #!/bin/bash mysql -uroot -pwhitehat test name it e.g. mymysql, make it executable and call echo "insert into..." | mymysql Have I missed the problem? mit freundlichen Gruessen / yours sincerely Gunther E. Biernat Web Application Engineer ______________________________________________________________ RealNetworks GmbH Tel.: +49-40-415204-24 Weidestraße 128 Fax.: +49-40-415204-11 22083 Hamburg Mail: GEBiernat@real.com Germany URL : http://de.real.com ______________________________________________________________