dynadb.query()

阅读(87) 标签: 查询, dynamodb, 序表,

描述:

查询dynamodb数据库

语法:

dynadb.query(sql)

dynadb.query(A,sql)

备注:

外部库函数,根据sql语句查询dynamodb外部库。

参数:

A

序列,针对A循环执行sql,利用A计算出不同的参数值传给sql执行

sql

sql语句

返回值:

序表

示例:

 

A

 

1

=dyna_open("http://localhost:8000", "us-east-2")

 

2

=A1.query("select * from emp")

 

3

=A1.query("select * from emp where lname in (?,?,?) and gender = ?","Gary","Eddy","Lee","F")

 

4

=A1.query("select * from emp where gender =?","M")

 

 

5

[201,'Joshua',205,'Emma',212,'Ryan']

 

6

=A1.query(A5, "select * from emp where pid = ? and fname=?")

 

7

>A1.close()