在Excel文件内添加语句
=”INSERT INTO products(id,Pname,Pclass) VALUES(“&A2&”,”&B2&”,”&C2&”);”
然后拖动填充柄
完成语句生成
| id | Pname | Pclass | 语句 |
| “00001″ | “手套” | “劳保用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00001″,”手套”,”劳保用品”); |
| “00002″ | “工装” | “劳保用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00002″,”工装”,”劳保用品”); |
| “00003″ | “鞋帽” | “劳保用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00003″,”鞋帽”,”劳保用品”); |
| “00004″ | “护肤品” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00004″,”护肤品”,”日用品”); |
| “00005″ | “洗发水” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00005″,”洗发水”,”日用品”); |
| “00006″ | “沐浴液” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00006″,”沐浴液”,”日用品”); |
| “00007″ | “扫把” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00007″,”扫把”,”日用品”); |
| “00008″ | “空气清新剂” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00008″,”空气清新剂”,”日用品”); |
| “00009″ | “洗涤灵” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00009″,”洗涤灵”,”日用品”); |
| “00010″ | “牙膏” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00010″,”牙膏”,”日用品”); |
| “00011″ | “牙刷” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00011″,”牙刷”,”日用品”); |
| “00012″ | “洗手液” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00012″,”洗手液”,”日用品”); |
| “00013″ | “肥皂” | “日用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00013″,”肥皂”,”日用品”); |
| “00014″ | “枕头” | “家居用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00014″,”枕头”,”家居用品”); |
| “00015″ | “被罩” | “家居用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00015″,”被罩”,”家居用品”); |
| “00016″ | “床单” | “家居用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00016″,”床单”,”家居用品”); |
| “00017″ | “电饭锅” | “厨房用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00017″,”电饭锅”,”厨房用品”); |
| “00018″ | “电磁炉” | “厨房用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00018″,”电磁炉”,”厨房用品”); |
| “00019″ | “燃气灶” | “厨房用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00019″,”燃气灶”,”厨房用品”); |
| “00020″ | “烤箱” | “厨房用品” | INSERT INTO products(id,Pname,Pclass) VALUES(“00020″,”烤箱”,”厨房用品”); |