mysql清空带外键的表

set FOREIGN_KEY_CHECKS =0;
TRUNCATE memo;
TRUNCATE customer;
set FOREIGN_KEY_CHECKS =1;