使用变量的分表查询

query.sql

set @uid=12345;
SET @tb=CONCAT('table_', lpad(mod(@uid, 64),2,0));
SET @sql = CONCAT('SELECT *,FROM_UNIXTIME(usedtime) FROM ',@tb,' where uid=', @uid);
PREPARE st FROM @sql;
EXECUTE st;
DEALLOCATE PREPARE st;