let
明细 = Table.TransformColumnTypes(Excel.CurrentWorkbook(){[Name="表1"]}[Content],{{"姓名",type text}})[姓名],
ip = "--------------------------------",
数据库 = "gh",
结果= MySQL.Database(ip, 数据库, [Query="insert into demo (id,demo) values (1,2)", ReturnSingleDatabase=true, CommandTimeout=#duration(0, 0, 2, 0)])
in
结果
我设置了一堆凭证什么的,但是最后还是保错
Expression.Error: Value 'Preferred' is not of the correct type