Mior Muhammad Zaki

Sample Data

Here I’m following the same database sample used in the Nettut’s CodeIgniter: From Scratch Day 5.

CREATE TABLE `data` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 250 ) NOT NULL ,
`content` TEXT NOT NULL
) ENGINE = MYISAM ;

To make things easier, here’s an insert statement to quickly have some sample data.

INSERT INTO `data` VALUES(1, 'Title 1', 'Here some content example');
INSERT INTO `data` VALUES(2, 'Title 2', 'Here some content example');
INSERT INTO `data` VALUES(3, 'Another Title', 'Here some content example');
INSERT INTO `data` VALUES(4, 'Another Title 2', 'Here some content example');

Pages: 1 2 3 4 5