/* Error occurs at the end of this example */

DROP TABLE IF EXISTS visitors;

CREATE TABLE visitors (

	año CHAR(4) NOT NULL,

	Jan INT(10) NOT NULL DEFAULT 0,

	Feb INT(10) NOT NULL DEFAULT 0,

	Mar INT(10) NOT NULL DEFAULT 0,

	Apr INT(10) NOT NULL DEFAULT 0,

	May INT(10) NOT NULL DEFAULT 0,

	Jun INT(10) NOT NULL DEFAULT 0,

	Jul INT(10) NOT NULL DEFAULT 0,

	Aug INT(10) NOT NULL DEFAULT 0,

	Sep INT(10) NOT NULL DEFAULT 0, 

	_Oct INT(10) NOT NULL DEFAULT 0,

	Nov INT(10) NOT NULL DEFAULT 0,

	Dic INT(10) NOT NULL DEFAULT 0 

) ENGINE = CONNECT;

INSERT INTO visitors VALUES

('2015', 121, 172, 199, 181, 108, 199, 171, 156, 170, 183, 105, 176),

('2014', 167, 108, 137, 161, 198, 104, 129, 132, 172, 167, 119, 196),

('2013', 120, 116, 117, 140, 148, 119, 154, 112, 101, 166, 131, 156),

('2012', 189, 175, 112, 132, 127, 141, 121, 186, 165, 169, 148, 136),

('2011', 134, 162, 108, 158, 163, 144, 129, 116, 193, 117, 105, 176);

DROP TABLE IF EXISTS xvisitors;

CREATE TABLE xvisitors (

	año CHAR(4) NOT NULL, 

	_month CHAR(3) NOT NULL,

	number INT(10) NOT NULL

) ENGINE=CONNECT TABLE_TYPE=OCCUR

tabname=visitors

option_list='OccurCol=number,RankCol=_month'

Colist='Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,_Oct,Nov,Dic';

SELECT * FROM xvisitors;

DROP TABLE IF EXISTS xvisitors2;

CREATE TABLE xvisitors2 (

	_year char(4) NOT NULL,

	_month char(4) NOT NULL,

	number int(10) NOT NULL

	) engine = CONNECT;

INSERT INTO xvisitors2 SELECT * FROM xvisitors;

/*error occurs in the following line*/

CREATE TABLE pvisitors ENGINE=CONNECT TABLE_TYPE=PIVOT

TABNAME=xvisitors2 Option_list='user=root password=admin';