SET 数据类型是存储唯一元素的无序集合类型。SET 数据类型中的元素个数可以变化,但不允许空值。
CREATE TABLE employee ( name char(30), address char(40), children SET (varchar(30) NOT NULL) );
Muriel|5555 SW Merry Sailing Dr.|02/06/1926|SET{'Karen','Lauren','Andrea'}| Larry|1234 Indian Lane|07/31/1927|SET{'Martha', 'Melissa','Craig','Larry'}|
FILE employee.unl DELIMITER '|' 4; INSERT INTO employee VALUES ('Marvin', '10734 Pardee', '06/17/27', "SET{'Joe', 'Ann'}");