|
With builtin table options, the = sign can be used but is optional:
MariaDB [test]> CREATE OR REPLACE TABLE t (a INT)
|
-> ENGINE = CONNECT
|
-> TABLE_TYPE = CSV
|
-> MIN_ROWS 1000;
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
But with engine-specific options, omitting the = sign results in a syntax error:
MariaDB [test]> CREATE OR REPLACE TABLE t (a INT)
|
-> ENGINE = CONNECT
|
-> TABLE_TYPE CSV;
|
ERROR 1064 (42000): 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 'CSV' at line 3
|
|