Tabla i podaci:
Code:
CREATE TABLE `test`.`t1` (
`id` INT NOT NULL AUTO_INCREMENT ,
`itemid` INT NOT NULL ,
`userid` INT NOT NULL ,
`grade` INT NULL ,
PRIMARY KEY (`id`) );
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (1, 1, 3);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (1, 2, 5);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (1, 4, 2);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (2, 1, 2);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (2, 4, 5);
CREATE TABLE `test`.`t1` (
`id` INT NOT NULL AUTO_INCREMENT ,
`itemid` INT NOT NULL ,
`userid` INT NOT NULL ,
`grade` INT NULL ,
PRIMARY KEY (`id`) );
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (1, 1, 3);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (1, 2, 5);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (1, 4, 2);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (2, 1, 2);
INSERT INTO `test`.`t1` (`itemid`, `userid`, `grade`) VALUES (2, 4, 5);
Pokusavam da dobijem nesto kao ovo:
itemid user1 user2 user3 user4
1 3 5 null 2
2 2 null null 5
I nikako ne ide.
Tko leti vrijedi