dear all,
i want to run bash script to delete some records by date, i wrote a script but i doesn't effect table.

Database name = uetek
tablename = stime
field = unixti

try echoing the value of '$daily' to see whether it actually is a valid date or not

Hi,

you pass your sql to bash which doesn't now much about it.

You should at least invoke the mysql client and pass your sql eg. by using the -e option

Andreas

I am sure you already got this, but here is an example of what sassermann was referring to:

mysql databasename -e "delete from stime where unixti<=unix_timestamp('$daily')"

I have used that format for running MySQL commands before and it works well, though you will of course want to verify that the variables are being passed as expected, and of course that they are formatted correctly.