CREATE TABLE IF NOT EXISTS `tbl` (
`id` int(10) unsigned NOT NULL auto_increment,
`caption` varchar(255) default NULL,
`content` longtext,
`submit_date` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
SELECT *
FROM data1
GROUP BY content
这样,就不会出现索引,表类型,AUTO_INCREMENT丢失的问题了,只是简单的create table a SELECT *
FROM data1
GROUP BY content会出现索引未建立的问题