PDv3hZns

1Yii DbMigration Moving Data to other table
2CREATE TABLE IF NOT EXISTS `old_table` (
3  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4  `title` varchar(255) NOT NULL,
5  `thumbnail` varchar(64) DEFAULT NULL,
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
8	
9CREATE TABLE IF NOT EXISTS `new_table` (
10  `old_id` int(11) unsigned NOT NULL, -- foreign key to old_table
11  `transformed_title` varchar(255) NOT NULL,
12  `thumbnail` varchar(64) DEFAULT NULL,
13  PRIMARY KEY (`id`)
14) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
15	
16INSERT INTO new_table (old_id, transformed_title, thumbnail)
17SELECT id, MYFUNCTION(title), thumbnail FROM old_table