工作需要,在Mybatis中动态创建数据表
<select id="createNewTable" parameterType="String">
<![CDATA[
CREATE TABLE ${tableName} (
id INT PRIMARY KEY AUTO_INCREMENT,
project_id VARCHAR(20) NOT NULL,
data VARCHAR(255),
serial_number VARCHAR(50) NOT NULL,
type INT(2) NOT NULL,
sync_mark INT(2) NOT NULL,
create_date VARCHAR(30),
modify_date VARCHAR(30) NOT NULL,
version VARCHAR(5))
]]>
</select>