From Perl Motmot, 12 Years ago, written in Plain Text.
This paste is a reply to Re: sql from Ample Frog - view diff
Embed
  1.  
  2.   for (( i=0 ; i<${#CACHE_TABLES[@]}; i++ )) ; do
  3.     TABLE="${TABLES_NAME[$i]}"
  4.     cecho "  TABLE=${TABLE}"
  5.     mysql_sql_exec "UPDATE ${TEMP_TABLE}, ${TABLE} SET ${TEMP_TABLE}.value='online' WHERE variable=variableid and timestamp >= ${TS_FROM};"  
  6.     logs "  Table name ${TABLE} analyzed."
  7.   done