excel中4个入门小技巧

页面:/news/view-582243/ | 耗时:0.7499 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=582243 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=582243 LIMIT 0,1
select * from tbl_Articles_sphinx where id=582243 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1048465,1427299,2764636,1101549,1980058,1210981,99158,911652,1050484,520285,1768378,3410099,1224459,1116545,3154420,430734,1925570,2190552,3423260,1000853,2390913,1105157,2998974,692177,1107563,486480,1234024,1234601,744542,3332851) ORDER BY field (ArticleID,1048465,1427299,2764636,1101549,1980058,1210981,99158,911652,1050484,520285,1768378,3410099,1224459,1116545,3154420,430734,1925570,2190552,3423260,1000853,2390913,1105157,2998974,692177,1107563,486480,1234024,1234601,744542,3332851)