The following table lists the variables that can be used with expiration commands in the MySQL Channel object’s SQL Expiration Commands property. For information on the SQL Expiration Commands property, see MySQL Channel Object.
IMPORTANT:When using SQL expiration command variables, remember the following:
In the following example scripts, note that l is the letter L as in lion.
create table newtable ($T) $e;RENAME TABLE $l TO l$n, newtable TO $l
This script does the following:
truncate table $l;
This script deletes the contents of the table.