插入
=CONCATENATE("INSERT INTO 表名(PERSONS_NO, PERSONS_NAME,ID_NUMBER) VALUES('" & C2 & "', '" & E2 & "', '" & F2 & "');")
更新
=CONCATENATE("UPDATE 表名 SET 字段='" & C2 & "',字段= '" & E2 & "',字段= '" & F2 & "' where 條件;")
查询
=CONCATENATE("select * from 表名 where 字段='" & C2 & "' and 字段= '" & E2 & "' and 字段= '" & F2 & "' ;")
=CONCATENATE("select 字段名 from 表名 where 字段='" & C2 & "' and 字段= '" & E2 & "' and 字段= '" & F2 & "' ;")
in的写法
="IN ("&TEXTJOIN(",",TRUE,"'"&A2:A10&"'")&")"