引用 | 编辑
hcrackpot
2009-05-21 01:24 |
楼主
▼ |
||
x1
假如我有这样的语句资料要导入SQLINSERT INTO `cdb_images_data` VALUES ('','8','下身','30','下身','30','f','ssf6.gif','ssf6x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','潇洒李奇裤装','30','潇洒李奇裤装','30','f','ssf413.gif','ssf413x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','中国功夫下装','30','中国功夫下装','30','f','ssf415.gif','ssf415x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','潇洒李奇裤装','30','潇洒李奇裤装','30','f','ssf418.gif','ssf418x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','可爱粉红嬉皮装','30','可爱粉红嬉皮装','30','f','ssf421.gif','ssf421x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','性感开衩群装','30','性感开衩群装','30','f','ssf422.gif','ssf422x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','动感casual女裤','30','动感casual女裤','30','f','ssf424.gif','ssf424x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('','8','气质雅皮绅士裤','30','气质雅皮绅士裤','30','f','ssf425.gif','ssf425x.gif','','','100','1'); ........ 有一千多句 我要如何将第一个 ' ' 里面依序填入递增数值呢 像这样 INSERT INTO `cdb_images_data` VALUES ('1781','8','下身','30','下身','30','f','ssf6.gif','ssf6x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('1782','8','潇洒李奇裤装','30','潇洒李奇裤装','30','f','ssf413.gif','ssf413x.gif','','','100','1'); INSERT INTO `cdb_images_data` VALUES ('1783','8','中国功夫下装','30','中国功夫下装','30','f','ssf415.gif','ssf415x.gif','','','100','1'); 有这种工具,可以帮我直接加入递增的数字进语句里的嘛? 谢谢 x1
|