DECLARE tableName VARCHAR(64) DEFAULT CONCAT('haha','_',DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 2 MONTH),'%Y%m'));
SET @sql1 = CONCAT('CREATE TABLE ',tableName, '(
a varchar(64) NOT NULL DEFAULT \'\' COMMENT \'a\',
b varchar(32) NOT NULL DEFAULT \'\' COMMENT \'b\',
c datetime NOT NULL COMMENT \'c\',
d decimal(12,4) NOT NULL COMMENT \'d\',
e datetime NOT NULL COMMENT \'e\',
PRIMARY KEY (a,b,e),
KEY idx_meter_id (a) USING HASH,
KEY idx_collect_time (c) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'haha\';'
);
問一下各位，為什么這個存盤程序創建這張表不成功
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/271042.html
標籤：MySQL