将Excel中的数据导出成SQL(即可导入MySQL等数据库了)
=CONCATENATE(“insert into students (school,name,stuno,gender,grade,mobile)values(“,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”,”,”‘”,A771,”‘”,”);”)
把上面的语句在单元格中输入，然后，将A771换成相应的单元格的编号即可，然后拖动就行了！
| Posted in 乱七八糟 | No Comments »