Excel表格转换成mysql插入insert语句

="insert into loc(city_code,city_name) values('"&A3&"','"&B3&"')"

 

 然后复制粘贴到文本，在linux服务器上面形成sql语句

 

 

 [root@mysql ~]# cat -n loc.sql

1 insert into loc(id,name) values('1','李明');
2 insert into loc(id,name) values('2','张三');
3 insert into loc(id,name) values('3','张军');
4 insert into loc(id,name) values('4','李达');
5 insert into loc(id,name) values('5','王虎');
6 insert into loc(id,name) values('6','一一');
7 insert into loc(id,name) values('7','李俊豪');
8 insert into loc(id,name) values('8','赵六');
9 insert into loc(id,name) values('9','赵焕军');
10 insert into loc(id,name) values('10','李四');
11 insert into loc(id,name) values('11','王一红');

 

mysql> select id,name from loc where name like '__';
+----+--------+
| id | name |
+----+--------+
| 1 | 李明 |
| 2 | 张三 |
| 3 | 张军 |
| 4 | 李达 |
| 5 | 王虎 |
| 6 | 一一 |
| 8 | 赵六 |
| 10 | 李四 |
+----+--------+
8 rows in set (0.00 sec)

mysql> select id,name from loc where name like '___';
+----+-----------+
| id | name |
+----+-----------+
| 7 | 李俊豪 |
| 9 | 赵焕军 |
| 11 | 王一红 |
+----+-----------+
3 rows in set (0.00 sec)

 

 

 

例子：

="insert into instructor(ID,name,dept_name,salary) values('"&A2&"','"&B2&"','"&C2&"','"&D2&"')"