hcrackpot
|
分享:
▼
x1
|
[SQL][求助] 請問有沒有SQL欄位遞增數值工具?
假如我有這樣的語句資料要導入SQL INSERT 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');
有這種工具,可以幫我直接加入遞增的數字進語句裡的嘛? 謝謝
|