i need to know how to update time of a table in mysql db

[mohammedss]

Hi everybody
I'm a new user for mysql,i'v an application running mysql db on a linux server ,
now i need to check the modification time of a table and compare with a previous
stored one and if it's newer it will run a script to delete some rows from it .
I wrote it with the help of a friend but i can't reach him now.
I tried the " show table status update_time " but i could not use it well
So can any one help me in this.
This is the written script:


#!/user/bin/bash
TMP_SQL_FILE=/tmp/removeData-$$.sql
/opt/ne/mysql/bin/mysql -uroot -pmysql -e"select id from NE_DSL where NAME like '%LAN'"| while read DSL_ID
do
echo "delete from NE_DSL_ATTRIBUTES where DSL_ID=$DSL_ID;" > $TMP_SQL_FILE
echo "delete from NE_DSL where ID=$DSL_ID;" >> $TMP_SQL_FILE
/opt/ni/mysql/bin/mysql -uroot -pmysql NE < $TMP_SQL_FILE
/opt/ni/mysql/bin/mysql -uroot -pmysql NE < $TMP_SQL_FILE > /dev/null 2> /dev/null
if [ $? -ne 0 ]; then
echo "Unable to remove DSL with id $DSL_ID!"
fi
done
rm $TMP_SQL_FILE



Thanks alot
Mohammed

[ronverdonk]

You can only get that information when the MySQL storage engine supports the UPDATE_TIME writing. Most engines do not.

Ronald