/* 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';
|