CREATE TABLE IF NOT EXISTS `works` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`age` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
实现方式
INSERT INTO `works` (`name`,`age`) SELECT `name`,`age` FROM `works`