通過ADOQuery連接ACCESS資料庫,庫里有一個欄位ID,已建立索引,索引名為indexID,請問如何寫SQL陳述句
按欄位查找:sql = "select * from Table order by ID desc"; 按索引怎么寫呢?參考別人的寫法如下會報錯
sql = "select * from Table order by indexID desc";
sql = "select * with index( indexID) from Table order by ID desc";
sql = "select * from Table order byindex( indexID) desc"; 均報錯
請大家賜教
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/85974.html
標籤:數據庫及相關技術
上一篇:警告用指標P時警告warning: assignment from incompatible pointer type| airline *modefy_air
