MySql 实现ROW_NUMBER()
老猿的春天 2015-10-26 11:25:55 我代码中使用 otl 通过ODBC连接MySql, 执行语句时抛出异常,找不到原因
代码如下
otl_stream os_db;
try
{
os_db.open(100,"select @curRow := @curRow + 1 as rowno,t.name from (select @curRow:= 0) t, emploee t ",conn_db);
while (!os_db.eof())
{
}
}
catch(otl_exception *e)
{
}
catch(...)
{
//执行open语句进入到此处。。!!!!!!!!
}