当我查询时
cs = con.cursor()
cs.execute("USE DATABASE DEV_TEST")
cs.execute(r"SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS")
它检索数据但是如果我放入WHERE
子句,它将不返回
cs.execute(r"SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TESTTABLE'")
你能帮我做什么不对吗
注:TESTTABLE
表存在于的正确位置
将变量名用双引号括起来。
https://support.snowflake.net/s/question/0D50Z00008aREunSAG/what-is-the-difference-between-single-quotes-and-double-quotes-in-snowflake