blocks|key|2062167|text|在Cassandra+CQL+2.0中，您可以拥有：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2062168|Cassandra1.2不允许为update语句的时间戳和TTL属性使用绑定标记，也不允许使用SELECT语句的极限属性。现在这个问题已经解决了，例如，您可以准备如下语句：|blockquote|2062169|SELECT+*+FROM+myTable+LIMIT+?;
UPDATE+myTable+USING+TTL+?+SET+v+=+2+WHERE+k+=+'foo';|code-block|syntax|javascript|2062170|有关更多信息，请参见他们的博客。|offset|length|2062171|编辑：|style|BOLD|2062172|我找到了此pdf，它告诉你更多：|2062173|边界参数：|2062174|驱动程序支持两种绑定参数:按标记和按名称。绑定参数？标记用于表示查询字符串中的绑定变量。这既用于常规查询，也用于准备参数化查询。除了将绑定标记添加到查询字符串之外，在构造新语句时，应用程序还必须向cass_statement_new()提供绑定变量的数量。如果查询不需要任何绑定变量，则可以使用0。然后使用cass_statement_bind_*()函数将值绑定到语句的变量。绑定变量可以由标记索引或名称绑定。|2062175|标记绑定索引示例|2062176|CassString+query+=+cass_string_init("SELECT+*+FROM+table1+WHERE+column1
+=+?");
/*+Create+a+statement+with+a+single+parameter+*/
CassStatement*+statement+=+cass_statement_new(query,+1);
cass_statement_bind_string(statement,+0,+cass_string_init("abc"));
/*+Execute+statement+*/
cass_statement_free(statement);|2062177|按标记名绑定示例|2062178|变量只能按已准备语句的名称绑定。存在此限制是因为需要由Cassandra提供的查询元数据将变量名映射到变量的标记索引。|2062179|/*+Prepare+statement+*/
/*+The+prepared+query+allocates+the+correct+number+of+parameters
+automatically+*/
CassStatement*+statement+=+cass_prepared_bind(prepared);
/*+The+parameter+can+now+be+bound+by+name+*/
cass_statement_bind_string_by_name(statement,+"column1",
+cass_string_init("abc"));
/*+Execute+statement+*/
cass_statement_free(statement);|2062180|回答您的问题，您可以使用bind索引(至少可以肯定)：|2062181|CassString+query+=+cass_string_init("INSERT+INTO+table+(column1,+column2,+column3)++VALUES+(?,+?,+?)+USING+TTL+?");
/*+Create+a+statement+with+a+single+parameter+*/
CassStatement*+statement+=+cass_statement_new(query,+4);+//+Bind+4+variables.
cass_statement_bind_string(statement,+0,+cass_string_init("abc"));+//+Bind+abc+to+first+column.
cass_statement_bind_string(statement,+1,+cass_string_init("bcd"));+//+Bind+bcd+to+second+column.
cass_statement_bind_string(statement,+2,+cass_string_init("cde"));+//+Bind+cde+to+third+column.
cass_statement_bind_string(statement,+3,+cass_string_init(50));+//+Bind+50+to+TTL.+++
/*+Execute+statement+*/
cass_statement_free(statement);|2062182|2062183|请参见使用/useExpireExample.html+e.html，在插入的情况下，我们使用TTL作为查询的最后一部分，如上文所示。|2062184|entityMap|0|LINK|mutability|MUTABLE|url|https://www.datastax.com/dev/blog/cql-in-cassandra-2-0|1|http://www.eandbsoftware.org/geek/wp-content/uploads/2016/02/cppDriver22.pdf|2|https://docs.datastax.com/en/cql/3.3/cql/cql_using/useExpireExample.html^0|0|0|0|D|2|0|0|0|3|0|4|4|1|0|0|5|0|0|0|8|0|0|0|8|0|0|0|0|R|0|0|0|3|0|3|V|2|0^^$0|@$1|2|3|4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1R|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|1S|8|@]|9|@]|A|$H|I]]|$1|J|3|K|5|6|7|1T|8|@]|9|@$L|1U|M|1V|1|1W]]|A|$]]|$1|N|3|O|5|6|7|1X|8|@$L|1Y|M|1Z|P|Q]]|9|@]|A|$]]|$1|R|3|S|5|6|7|20|8|@]|9|@$L|21|M|22|1|23]]|A|$]]|$1|T|3|U|5|6|7|24|8|@$L|25|M|26|P|Q]]|9|@]|A|$]]|$1|V|3|W|5|D|7|27|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|28|8|@$L|29|M|2A|P|Q]]|9|@]|A|$]]|$1|Z|3|10|5|G|7|2B|8|@]|9|@]|A|$H|I]]|$1|11|3|12|5|6|7|2C|8|@$L|2D|M|2E|P|Q]]|9|@]|A|$]]|$1|13|3|14|5|D|7|2F|8|@]|9|@]|A|$]]|$1|15|3|16|5|G|7|2G|8|@]|9|@]|A|$H|I]]|$1|17|3|18|5|6|7|2H|8|@$L|2I|M|2J|P|Q]]|9|@]|A|$]]|$1|19|3|1A|5|G|7|2K|8|@]|9|@]|A|$H|I]]|$1|1B|3|O|5|6|7|2L|8|@$L|2M|M|2N|P|Q]]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2O|8|@]|9|@$L|2P|M|2Q|1|2R]]|A|$]]|$1|1E|3|-4|5|6|7|2S|8|@]|9|@]|A|$]]]|1F|$1G|$5|1H|1I|1J|A|$1K|1L]]|1M|$5|1H|1I|1J|A|$1K|1N]]|1O|$5|1H|1I|1J|A|$1K|1P]]]]

In Cassandra CQL 2.0 you can have:

<blockquote>
 Cassandra 1.2 doesn't allow you to use a bind marker for the TIMESTAMP and TTL properties of update statements, nor for the LIMIT property of SELECT statements. This is now fixed and you can for instance prepare statements like:
</blockquote>

<pre><code>SELECT * FROM myTable LIMIT ?;
UPDATE myTable USING TTL ? SET v = 2 WHERE k = 'foo';
</code></pre>

See their <a href="https://www.datastax.com/dev/blog/cql-in-cassandra-2-0" rel="nofollow noreferrer">blog</a> for more. 

Edit:

I found <a href="http://www.eandbsoftware.org/geek/wp-content/uploads/2016/02/cppDriver22.pdf" rel="nofollow noreferrer">this pdf</a> and it tells you more:

Bound parameters:

<blockquote>
 The driver supports two kinds of bound parameters: by marker and by name.
 Binding parameters
 The ? marker is used to denote the bind variables in a query string. This is used for both regular
 and prepared parameterized queries. In addition to adding the bind marker to your query string,
 your application must also provide the number of bind variables to 
 cass_statement_new() when constructing a new statement. If a query doesn’t require any bind variables then 0 can be used. The cass_statement_bind_*()
 functions are then used to bind values to the statement’s variables.
 Bind variables can be bound by the marker index or by name.
</blockquote>

Bind by marker index example

<pre><code>CassString query = cass_string_init("SELECT * FROM table1 WHERE column1
 = ?");
/* Create a statement with a single parameter */
CassStatement* statement = cass_statement_new(query, 1);
cass_statement_bind_string(statement, 0, cass_string_init("abc"));
/* Execute statement */
cass_statement_free(statement);
</code></pre>

Bind by marker name example

<blockquote>
 Variables can only be bound by name for prepared statements. This limitation exists because query
 metadata provided by Cassandra is required to map the variable name to the variable’s marker index.
</blockquote>

<pre><code>/* Prepare statement */
/* The prepared query allocates the correct number of parameters
 automatically */
CassStatement* statement = cass_prepared_bind(prepared);
/* The parameter can now be bound by name */
cass_statement_bind_string_by_name(statement, "column1",
 cass_string_init("abc"));
/* Execute statement */
cass_statement_free(statement);
</code></pre>

To answer your question you can use bind by index (works at least for sure):

<pre><code>CassString query = cass_string_init("INSERT INTO table (column1, column2, column3) VALUES (?, ?, ?) USING TTL ?");
/* Create a statement with a single parameter */
CassStatement* statement = cass_statement_new(query, 4); // Bind 4 variables.
cass_statement_bind_string(statement, 0, cass_string_init("abc")); // Bind abc to first column.
cass_statement_bind_string(statement, 1, cass_string_init("bcd")); // Bind bcd to second column.
cass_statement_bind_string(statement, 2, cass_string_init("cde")); // Bind cde to third column.
cass_statement_bind_string(statement, 3, cass_string_init(50)); // Bind 50 to TTL. 
/* Execute statement */
cass_statement_free(statement);
</code></pre>

Edit:

See <a href="https://docs.datastax.com/en/cql/3.3/cql/cql_using/useExpireExample.html" rel="nofollow noreferrer">https://docs.datastax.com/en/cql/3.3/cql/cql_using/useExpireExample.html</a> where you see that in case of INSERT we have USING TTL as last part of query, as seen above.

blocks|key|827668|text|我试验了卡桑德拉C%2B%2B驱动程序2.11。我发现|type|unstyled|depth|inlineStyleRanges|entityRanges|data|827669|TTL只能由位置绑定，我们应该使用(cass_int32_t)数据来绑定TTL值。
例子:cass_statement_bind_int32(语句，2，(cass_int32_t)20)；|ordered-list-item|827670|cass_statement_bind_int32_by_name不能工作
例:cass_statement_bind_int32_by_name(陈述，2，(cass_int32_t)20)；//不起作用|827671|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|K|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|L|8|@]|9|@]|A|$]]]|H|$]]

I have experimented with Cassandra C++ driver 2.11. I have found following
<ol>
<li>TTL can be bound by position only and we should use (cass_int32_t) data for binding TTL value
Example: cass_statement_bind_int32(statement, 2, (cass_int32_t)20);
</li>
<li>cass_statement_bind_int32_by_name won't work
Ex: cass_statement_bind_int32_by_name(statement, 2, (cass_int32_t)20); //won't work
</li>
</ol>

I'm using prepared statements in the Cassandra Datastax C++ Driver. How do I bind an integer-value to the "USING TTL ?" part of a prepared statement?

My statement would be something like

<pre><code>INSERT INTO table (column1, column2, column3) VALUES (?, ?, ?) USING TTL ?
</code></pre>

In other words, If I'm using the position to bind to TTL, what is its position? (In this example, is it 4?) If I'm using bind by column name, what is its column name?

It looks like this can be done in CQL, but I couldn't find any documentation about the C++ driver API for doing this.

How to bind a value to TTL in INSERT, Cassandra C++ driver

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在Cassandra C++驱动程序中使用准备好的语句。如何将整数值绑定到“使用TTL ?”准备好的陈述的一部分？我的声明就像INSERT INTO table (column1, column2, column3)  VALUES (?, ?, ?) USING TTL ?换句话说，如果我使用这个位置绑定到TTL，...

问如何将值绑定到插入( Cassandra C++ )驱动程序中的TTL
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将值绑定到插入( Cassandra C++ )驱动程序中的TTLEN