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;

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

发表评论

您的电子邮箱地址不会被公开。