mysql 添加大量数据

标准

通过复制数据表的数据,不断添加,例如:

insert into ds_photo_book(isvideo,toppic,booktitle,style,hometype,area,moneys,homesize,bookcon,userid,ispass,clicks,piccount,talkcount,addtime) select isvideo,toppic,booktitle,style,hometype,area,moneys,homesize,bookcon,userid,ispass,clicks,piccount,talkcount,addtime from ds_photo_book;

不过此方法添加的数据较为单一。

发表评论