VC 用MySQL API 连接数据库，如何返回查询的总数？

好多人做法是，写两条条件相同的语句

一条查询总数一条查询结果

select

count(*)

from

tab1

where

name

like

'aaa'

select

*

from

tab1

where

name

like

'aaa'

limit

0,10

还有别的办法吗？谢谢!

对我有用[0]丢个板砖[0]引用举报管理TOPrucypli(我要冰糖)等

级：

或者绑定变量，官网例子：

MYSQL_TIME ts

MYSQL_BIND bind[3]

MYSQL_STMT *stmt

strmov(query, "INSERT INTO test_table(date_field, time_field,

timestamp_field) VALUES(?,?,?")

stmt = mysql_stmt_init(mysql)

if (!stmt)

{

fprintf(stderr, " mysql_stmt_init(), out of memory\n")

exit(0)

}

if (mysql_stmt_prepare(mysql, query, strlen(query)))

{

fprintf(stderr, "\n mysql_stmt_prepare(), INSERT failed")

fprintf(stderr, "\n %s", mysql_stmt_error(stmt))

exit(0)

}

/* set up input buffers for all 3 parameters */

bind[0].buffer_type= MYSQL_TYPE_DATE

bind[0].buffer= (char *)&ts

bind[0].is_null= 0

bind[0].length= 0

...

bind[1]= bind[2]= bind[0]

...

mysql_stmt_bind_param(stmt, bind)

/* supply the data to be sent in the ts structure */

ts.year= 2002

ts.month= 02

ts.day= 03

ts.hour= 10

ts.minute= 45

ts.second= 20

mysql_stmt_execute(stmt)

---