php mysqli 执行建立索引语句报错

Question

$creatTableSql = <<<EOF
CREATE TABLE IF NOT EXISTS duplicate_attachment(
    id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    md5 VARCHAR(32) NOT NULL,
    filesize INT(11),
    ids TEXT NOT NULL
);

CREATE UNIQUE INDEX duplicate_attachment_id_uindex ON duplicate_attachment (id);

CREATE UNIQUE INDEX duplicate_attachment_md5_uindex ON duplicate_attachment (md5);
EOF;
$mysqli->query($creatTableSql);
var_dump($mysqli->error);

string(226) "You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'CREATE UNIQUE INDEX duplicate_attachment_id_uindex ON
duplicate_attachment (id

);' at line 8"

Answer 1

应该用mysqli->multi_query