use test; drop table if exists test; create table test ( test_set set( 'val1', 'val2', 'val3' ) not null default '', name char(20) default 'O''Brien' ) comment = 'it\'s a table' ; @r/shw000001.result show create table test ;