MariaDB服务器版本用于正确的语法使用附近

I have a problem in ezSQL.

Code:

$dbo->query("INSERT INTO chart_logs (chart_id, uname, option_id) VALUES ('1', '1', '1'); INSERT INTO chart_logs (chart_id, uname, option_id) VALUES ('2', '2', '2'); ");

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT INTO chart_logs (chart_id, uname, option_id) VALUES ('2', '2', '2')' at line 1

But,

This Sql Query works phpmyadmin SQL Command successfully. I dont understand this. Why sql code doesnt work in ezsql query?

ezSQL does not support running multiple statements in a single query. Each statement must be executed in a separate query.

Original answer:

Run just one SQL statement.

MariaDB supports multirow insert with VALUES clause...

  INSERT INTO chart_logs (chart_id, uname, option_id) VALUES
    ('1', '1', '1')
  , ('2', '2', '2')