简单SQL语句中如何带参与执行

先做原表备份
CREATE TABLE A_1 AS SELECT * FROM A WHERE aa IN ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
CREATE TABLE B_1 AS SELECT * FROM B WHERE aa IN ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
CREATE TABLE C_1 AS SELECT * FROM C WHERE aa IN ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
CREATE TABLE D_1 AS SELECT * FROM D WHERE aa IN ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
CREATE TABLE E_1 AS SELECT * FROM E WHERE aa IN ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
........
在做原表数据删除
delete FROM A where aa in ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
delete FROM B where aa in ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
delete FROM C where aa in ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
delete FROM D where aa in ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
delete FROM E where aa in ('eimdmc','30mdnci','cienc03','39n33ndc','c035mcie','cnencc0394','cnednc003','ciiencec004','cinendnc00','2098472bnc','cnenndcj93','398473c3d','cjbebcencc','397c73becu','393knencne','398883jjdnc','83737jecnd','398838cjebc','e993nndn3','dii3nndn','300993983d');
........
这两个组的语句中 in 后面都有很长的参数，而且都是完全一样的。
怎么能够用参数替代这个in之后的语句。
希望使用简单sql

是的，讲这些数据放到一张表里，然后 select * from xxx where 字段 in (select 字段 from tablexxxx)

表in后面的参数放到一个临时表中，做表关联查询备份、删除即可。

表关联可以用join、exists、in。

关于join的详细用法及优化可以参考：
mysql join语法及优化 http://www.data.5helpyou.com/article209.html

关于join、exists、in的用法区别可以参考：
EXISTS、IN与JOIN的用法区别 http://www.data.5helpyou.com/article307.html