MariaDB [test]> show create table assets ;
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| assets | CREATE TABLE `assets` (
`item_name` varchar(32) NOT NULL,
`dynamic_cols` blob,
PRIMARY KEY (`item_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
MariaDB [test]> insert into assets values ('MariaDB T-shirt', COLUMN_CREATE('color', 'blue', 'size', 'XL'));
ERROR 1921 (22007): Illegal value used as argument of dynamic column function
MariaDB [test]> select version();
+--------------------+
| version() |
+--------------------+
| 5.5.31-MariaDB-log |
+--------------------+
1 row in set (0.00 sec)
Why?
--
姓名： river/吴炳锡 手机：13501245755
http://www.mysqlsupport.cn
创业公司MySQL 支持，优化，架构设计