问为MySQL存储过程中的所有表设置默认排序规则

EN

-- SAMPLE BLOCK A --   
DROP TABLE IF EXISTS abc;   

SET @createTable = CONCAT("CREATE TABLE "abc"(   
record_id VARCHAR(255),   
member VARCHAR(255),   
name VARCHAR(255)   
)CHARACTER SET 'utf8'    
COLLATE 'utf8_unicode_ci'");   

PREPARE create_table_statement FROM @createTable;   
EXECUTE create_table_statement;   
DEALLOCATE PREPARE create_table_statement;   

-- SAMPLE BLOCK B--   
DROP TABLE IF EXISTS def;   

SET @createTable1 = CONCAT("CREATE TABLE "def"(   
address VARCHAR(255),   
member_gender VARCHAR(255),   
member_age VARCHAR(255)     
)CHARACTER SET 'utf8'    
COLLATE 'utf8_unicode_ci'");   

PREPARE create_table_statement1 FROM @createTable1;   
EXECUTE create_table_statement1;   
DEALLOCATE PREPARE create_table_statement1;   
.   
.