Mysql Query in a Shell file?

[sema1995]

Hello, i'm tryiing to use a query in a shell file but i not know the sintax, anyone can help me?

Here a example:

PHP Code:

#!/bin/sh
os.execute("mysql Update auktionhaus.auktionhaus_items SET tiempo = tiempo -3600 where tiempo > 3600")
But not work xd 


Thanks.

[Damn']

PHP Code:

!/bin/bash
mysql -u root -pPASSWORD<<EOF
Update auktionhaus.auktionhaus_items SET tiempo = tiempo -3600 where tiempo > 3600;
EOF 


[sema1995]

Originally Posted by ****'

PHP Code:

!/bin/bash
mysql -u root -pPASSWORD<<EOF
Update auktionhaus.auktionhaus_items SET tiempo = tiempo -3600 where tiempo > 3600;
EOF 


Thanks for reply but..
Bash not found and i put now, !/bin/sh and...

[Damn']

you should enter -pPASSWORD to you password ^^

[sema1995]

Originally Posted by ****'

you should enter -pPASSWORD to you password ^^

Yes, now i understand works fine, thanks

[#dynastie]

Use -e/--e Parameter. Better than EOF-methode.